View In:
ArcGIS Online Map Viewer
Name: Address Points
Display Field: site_name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The address standard aims to achieve consistency around the data collected for UBC Campus Address (Vancouver and Okanagan campuses), and the format in which it is collected and stored in across the University. This will include the physical locations in a standardized form for all civic and non-civic addresses at UBC to be shared with Emergency Responders.</SPAN></P><P><SPAN>The Standard for coding UBC Campus Location address is adopted from the Physical Address and Geocoding Standards, developed by the government of British Columbia. </SPAN></P><P><SPAN>The conceptual model consists of an information model that defines the hierarchy, classes and spatial associations needed to represent sites and physical addresses, and a service model for geocoding. </SPAN></P><P><SPAN>https://cio.ubc.ca/data-governance/policies-standards-guidelines/data-standards/campus-address-data-standard</SPAN></P><P><SPAN /></P><P><SPAN>The following are the data elements that make up a campus address:</SPAN></P><P><SPAN /></P><TABLE><TBODY><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Unit_Designator</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>The type of unit</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Unit_Number_Prefix</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>A single alphabetic character or list of alphabetic characters and ranges, that is placed before the unit number.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Unit_Number</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>The number or range of numbers that identify units/ suites/buildings within a building or complex. For ADDRESS_DESCRIPTOR = CampusBldg, this must be a single value not a range.</SPAN></P></TD></TR><TR><TD><P><SPAN>Unit_Number_Suffix</SPAN></P></TD><TD><P><SPAN>A single alphabetic character or list of alphabetic characters and ranges, that follow the unit number. </SPAN></P><P><SPAN /></P></TD></TR><TR><TD><P><SPAN>Site_Name</SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>A string containing the name of a site. A business or occupant name should only be used if it is permanently affixed to the site and the site has no other, more generic name (ADDRESS_DESCRIPTOR = {Occupant, Commercial}).</SPAN></P><P><SPAN>If a site is a unit within a complex, it may have a sitename in addition to a unitNumber and unitNumberSuffix. This site name will be repeated for each unit.</SPAN></P><P><SPAN /></P></TD></TR><TR><TD><P><SPAN>Super_Full_Site_Descriptor</SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>Name of all units, buildings and sites in parent site hierarchy separated by a double dash. To identify buildings in a complex or sub-buildings in a building.</SPAN></P><P><SPAN /></P></TD></TR><TR><TD><P><SPAN>Civic_Number</SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>The number assigned to a site on a street by an address authority.</SPAN></P></TD></TR><TR><TD><P><SPAN>Civic_Number_Suffix </SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>A letter or fraction following the civic number.</SPAN></P></TD></TR><TR><TD><P><SPAN>Street_Name </SPAN></P></TD><TD><P><SPAN>Recognized by the municipality as the official name of the street.</SPAN></P><P><SPAN /></P></TD></TR><TR><TD><P><SPAN>Street_Type</SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>The type of street. Use the full word.</SPAN></P><P><SPAN /></P></TD></TR><TR><TD><P><SPAN>Street_Direction</SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>Canada Post street direction.</SPAN></P></TD></TR><TR><TD><P><SPAN>Locality </SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>The name of the locality assigned to a given site by an address authority. </SPAN></P><P><SPAN /></P></TD></TR><TR><TD><P><SPAN>Postal_Code</SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>Postal Code assigned by Canada Post for the purposes to deliver mail. Required once STATUS = Complete (Canada Post assigns postal code).</SPAN></P><P><SPAN /></P></TD></TR><TR><TD><P><SPAN>Province_Code</SPAN></P><P><SPAN /></P></TD><TD><P><SPAN>The ISO 3166-2 Sub-Country Code.</SPAN></P><P><SPAN /></P></TD></TR></TBODY></TABLE><P><SPAN /></P><P /><P><SPAN>Created: 11/22/2017</SPAN></P><P><SPAN>Updated: On an as needed basis. Addresses assigned by C+CP for the Vancouver campus. </SPAN></P></DIV></DIV></DIV>
Service Item Id: a35c945c21a147cf815692b8781e05df
Copyright Text: Campus + Community Planning
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 1200.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
XMin: 481001.0267000003
YMin: 5454531.505400004
XMax: 483401.6910000015
YMax: 5457820.646399999
Spatial Reference: 26910
(26910)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
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: 10
Font Family: Arial Black
Font Style: normal
Font Weight: normal
Font Decoration: none
Min. Scale: 1200.0
Max. Scale: 0.0
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
objectid
(
nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID
)
-
add_uid
(
modelName: add_uid, nullable: true, editable: true, defaultValue: null, length: 10, alias: ADD_UID, type: esriFieldTypeString
)
-
unit_designator
(
modelName: unit_designator, nullable: true, editable: true, defaultValue: null, length: 50, alias: UNIT_DESIGNATOR, type: esriFieldTypeString
)
-
unit_number_prefix
(
modelName: unit_number_prefix, nullable: true, editable: true, defaultValue: null, length: 20, alias: UNIT_NUMBER_PREFIX, type: esriFieldTypeString
)
-
unit_number
(
modelName: unit_number, nullable: true, editable: true, defaultValue: null, length: 30, alias: UNIT_NUMBER, type: esriFieldTypeString
)
-
unit_number_suffix
(
modelName: unit_number_suffix, nullable: true, editable: true, defaultValue: null, length: 10, alias: UNIT_NUMBER_SUFFIX, type: esriFieldTypeString
)
-
site_name
(
modelName: site_name, nullable: true, editable: true, defaultValue: null, length: 200, alias: SITE_NAME, type: esriFieldTypeString
)
-
super_full_site_descriptor
(
modelName: super_full_site_descriptor, nullable: true, editable: true, defaultValue: null, length: 400, alias: SUPER_FULL_SITE_DESCRIPTOR, type: esriFieldTypeString
)
-
civic_number
(
modelName: civic_number, nullable: true, editable: true, defaultValue: null, alias: CIVIC_NUMBER, type: esriFieldTypeInteger
)
-
civic_number_suffix
(
modelName: civic_number_suffix, nullable: true, editable: true, defaultValue: null, length: 10, alias: CIVIC_NUMBER_SUFFIX, type: esriFieldTypeString
)
-
street_name
(
modelName: street_name, nullable: true, editable: true, defaultValue: null, length: 100, alias: STREET_NAME, type: esriFieldTypeString
)
-
street_type
(
modelName: street_type, nullable: true, editable: true, defaultValue: null, length: 20, alias: STREET_TYPE, type: esriFieldTypeString
)
-
is_street_type_prefix
(
modelName: IS_STREET_TYPE_PREFIX, nullable: true, editable: true, defaultValue: null, alias: IS_STREET_TYPE_PREFIX, type: esriFieldTypeSmallInteger
, Coded Values:
[1: True]
, [0: False]
)
-
street_direction
(
modelName: street_direction, nullable: true, editable: true, defaultValue: null, length: 20, alias: STREET_DIRECTION, type: esriFieldTypeString
)
-
is_street_direction_prefix
(
modelName: IS_STREET_DIRECTION_PREFIX, nullable: true, editable: true, defaultValue: null, alias: IS_STREET_DIRECTION_PREFIX, type: esriFieldTypeSmallInteger
, Coded Values:
[1: True]
, [0: False]
)
-
locality
(
modelName: locality, nullable: true, editable: true, defaultValue: null, length: 100, alias: LOCALITY, type: esriFieldTypeString
)
-
locality_descriptor
(
modelName: locality_descriptor, nullable: true, editable: true, defaultValue: null, length: 50, alias: LOCALITY_DESCRIPTOR, type: esriFieldTypeString
)
-
postal_code
(
modelName: postal_code, nullable: true, editable: true, defaultValue: null, length: 7, alias: POSTAL_CODE, type: esriFieldTypeString
)
-
province_code
(
modelName: province_code, nullable: true, editable: true, defaultValue: null, length: 2, alias: PROVINCE_CODE, type: esriFieldTypeString
)
-
status
(
modelName: STATUS, nullable: true, editable: true, defaultValue: null, length: 20, alias: STATUS, type: esriFieldTypeString
, Coded Values:
[Current: Current]
, [Pending: Pending]
, [Retired: Retired]
, ...2 more...
)
-
is_official_address
(
modelName: IS_OFFICIAL_ADDRESS, nullable: true, editable: true, defaultValue: null, alias: IS_OFFICIAL_ADDRESS, type: esriFieldTypeSmallInteger
, Coded Values:
[1: True]
, [0: False]
)
-
is_primary
(
modelName: IS_PRIMARY, nullable: true, editable: true, defaultValue: null, alias: IS_PRIMARY, type: esriFieldTypeSmallInteger
, Coded Values:
[1: True]
, [0: False]
)
-
bldg_uid
(
modelName: bldg_uid, nullable: true, editable: true, defaultValue: null, length: 10, alias: BLDG_UID, type: esriFieldTypeString
)
-
address_descriptor
(
modelName: ADDRESS_DESCRIPTOR, nullable: true, editable: true, defaultValue: null, length: 30, alias: ADDRESS_DESCRIPTOR, type: esriFieldTypeString
, Coded Values:
[CampusBuilding: CampusBuilding]
, [Emergency: Emergency]
, [Commercial: Commercial]
, ...7 more...
)
-
site_point_descriptor
(
modelName: SITE_POINT_DESCRIPTOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: SITE_POINT_DESCRIPTOR, type: esriFieldTypeString
, Coded Values:
[Parcel: Parcel]
, [FrontDoor: FrontDoor]
, [Rooftop: Rooftop]
, ...4 more...
)
-
footprint_descriptor
(
modelName: FOOTPRINT_DESCRIPTOR, nullable: true, editable: true, defaultValue: null, length: 20, alias: FOOTPRINT_DESCRIPTOR, type: esriFieldTypeString
, Coded Values:
[Building: Building]
, [Complex: Complex]
, [OutdoorArea: OutdoorArea]
, ...3 more...
)
-
footprint_id
(
modelName: footprint_id, nullable: true, editable: true, defaultValue: null, length: 10, alias: FOOTPRINT_ID, type: esriFieldTypeString
)
-
is_non_civic_address
(
modelName: IS_NON_CIVIC_ADDRESS, nullable: true, editable: true, defaultValue: null, alias: IS_NON_CIVIC_ADDRESS, type: esriFieldTypeSmallInteger
, Coded Values:
[1: True]
, [0: False]
)
-
narritive_location
(
modelName: narritive_location, nullable: true, editable: true, defaultValue: null, length: 400, alias: NARRITIVE_LOCATION, type: esriFieldTypeString
)
-
is_mailing_address
(
modelName: IS_MAILING_ADDRESS, nullable: true, editable: true, defaultValue: null, alias: IS_MAILING_ADDRESS, type: esriFieldTypeSmallInteger
, Coded Values:
[1: True]
, [0: False]
)
-
mail_provider
(
modelName: MAIL_PROVIDER, nullable: true, editable: true, defaultValue: null, length: 20, alias: MAIL_PROVIDER, type: esriFieldTypeString
, Coded Values:
[CanadaPost: CanadaPost]
, [CampusMail: CampusMail]
)
-
is_annunciator
(
modelName: IS_ANNUNCIATOR, nullable: true, editable: true, defaultValue: null, alias: IS_ANNUNCIATOR, type: esriFieldTypeSmallInteger
, Coded Values:
[1: True]
, [0: False]
)
-
num_of_units
(
modelName: num_of_units, nullable: true, editable: true, defaultValue: null, alias: NUM_OF_UNITS, type: esriFieldTypeInteger
)
-
neighbourhood
(
modelName: neighbourhood, nullable: true, editable: true, defaultValue: null, length: 50, alias: NEIGHBOURHOOD, type: esriFieldTypeString
)
-
address_notes
(
modelName: address_notes, nullable: true, editable: true, defaultValue: null, length: 400, alias: ADDRESS_NOTES, type: esriFieldTypeString
)
-
created_user
(
modelName: CREATED_USER, nullable: true, editable: false, defaultValue: null, length: 255, alias: CREATED_USER, type: esriFieldTypeString
)
-
created_date
(
modelName: CREATED_DATE, nullable: true, editable: false, defaultValue: null, length: 29, alias: CREATED_DATE, type: esriFieldTypeDate
)
-
last_edited_user
(
modelName: LAST_EDITED_USER, nullable: true, editable: false, defaultValue: null, length: 255, alias: LAST_EDITED_USER, type: esriFieldTypeString
)
-
last_edited_date
(
modelName: LAST_EDITED_DATE, nullable: true, editable: false, defaultValue: null, length: 29, alias: LAST_EDITED_DATE, type: esriFieldTypeDate
)
-
parent_uid
(
modelName: PARENT_UID, nullable: true, editable: true, defaultValue: null, length: 10, alias: PARENT_UID, type: esriFieldTypeString
)
-
full_address
(
modelName: FULL_ADDRESS, nullable: true, editable: true, defaultValue: null, length: 300, alias: FULL_ADDRESS, type: esriFieldTypeString
)
-
anno_street_check
(
modelName: anno_street_check, nullable: true, editable: true, defaultValue: null, length: 20, alias: ANNO_STREET_CHECK, type: esriFieldTypeString
)
-
anno_street_dist
(
modelName: anno_street_dist, nullable: true, editable: true, defaultValue: null, alias: ANNO_STREET_DIST, type: esriFieldTypeDouble
)
-
anno_street_angle
(
modelName: anno_street_angle, nullable: true, editable: true, defaultValue: null, alias: ANNO_STREET_ANGLE, type: esriFieldTypeDouble
)
-
globalid
(
nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GLOBALID
)
Templates:
-
Name: Address Points
Description:
Prototype:
is_official_address: null
street_direction: null
num_of_units: null
is_primary: null
anno_street_angle: null
is_street_direction_prefix: null
is_non_civic_address: null
unit_number_suffix: null
anno_street_dist: null
full_address: null
province_code: null
footprint_descriptor: null
street_name: null
super_full_site_descriptor: null
bldg_uid: null
is_street_type_prefix: null
mail_provider: null
unit_number: null
parent_uid: null
anno_street_check: null
neighbourhood: null
narritive_location: null
unit_designator: null
footprint_id: null
is_mailing_address: null
civic_number_suffix: null
address_descriptor: null
locality: null
site_point_descriptor: null
site_name: null
address_notes: null
unit_number_prefix: null
locality_descriptor: null
civic_number: null
street_type: null
is_annunciator: null
postal_code: null
add_uid: null
status: null
Drawing Tool: esriFeatureEditToolPoint
Relationships:
-
v_building_Buildings (0) -- Related To:
Buildings (2)
Capabilities: Query
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Attachments
Query Related Records
Calculate
Validate SQL
Generate Renderer
Return Updates
Metadata