All Layers and Tables (Site_Structure_Address

Layers:

Layer: SiteStructureAddressPoint (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[145,140,47,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
featureid (type: esriFieldTypeString, alias: Feature ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
add_pt_key (type: esriFieldTypeString, alias: Address Point Key, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Add_Number (type: esriFieldTypeInteger, alias: Address Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
St_Name (type: esriFieldTypeString, alias: Road Name Body, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
full_add (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Inc_Muni (type: esriFieldTypeString, alias: Municipality (A3), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Province (type: esriFieldTypeString, alias: Province/Territory (A1), SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AB: Alberta], [BC: British Columbia], [MB: Manitoba], ... 10 more ...)
AddNum_Pre (type: esriFieldTypeString, alias: Address Number Prefix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
AddNum_Suf (type: esriFieldTypeString, alias: Address Number Suffix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
civicid (type: esriFieldTypeString, alias: Civic ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
parcelid (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Post_Code (type: esriFieldTypeString, alias: Postal Code, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
St_PreDir (type: esriFieldTypeString, alias: Directional Prefix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Central: Central], [Centre: Centre], [East: East], ... 23 more ...)
St_PreMod (type: esriFieldTypeString, alias: Modifier Prefix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
St_PosMod (type: esriFieldTypeString, alias: Modifier Suffix, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
St_PosDir (type: esriFieldTypeString, alias: Directional Suffix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Central: Central], [Centre: Centre], [East: East], ... 23 more ...)
St_PreSep (type: esriFieldTypeString, alias: Name Pre Type Separator , SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [à: à], [à l’: à l’], [at: at], ... 29 more ...)
St_PreTyp (type: esriFieldTypeString, alias: Road Type Prefix, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Abbey: Abbey], [Access: Access], [Acres: Acres], ... 159 more ...)
St_PosTyp (type: esriFieldTypeString, alias: Road Type Suffix, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Abbey: Abbey], [Access: Access], [Acres: Acres], ... 159 more ...)
agency (type: esriFieldTypeString, alias: Addressing Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pointtype (type: esriFieldTypeString, alias: Address Point Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Building Centroid: Building Centroid], [Building Entrance: Building Entrance], [Driveway Entrance: Driveway Entrance], ... 8 more ...)
regional_district (type: esriFieldTypeString, alias: Regional District, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Nbrhd_Comm (type: esriFieldTypeString, alias: Neighbourhood Community (A5), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
altname1 (type: esriFieldTypeString, alias: Alternate Name 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
altname2 (type: esriFieldTypeString, alias: Alternate Name 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
addressnotes (type: esriFieldTypeString, alias: Address Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Unit (type: esriFieldTypeString, alias: Unit Number, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
unitnumsuffix (type: esriFieldTypeString, alias: Unit Number Suffix, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
unittype (type: esriFieldTypeString, alias: Unit Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Appartement: Appartement], [Apartment: Apartment], [Bureau: Bureau], ... 3 more ...)
currentstatus (type: esriFieldTypeSmallInteger, alias: Current Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Approved], [2: For Review], [3: Retired], ... 3 more ...)
createddate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
revisiondate (type: esriFieldTypeDate, alias: Revision Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
approveddate (type: esriFieldTypeDate, alias: Approved Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
activedate (type: esriFieldTypeDate, alias: Active Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
autogenvalue (type: esriFieldTypeInteger, alias: Autgenerated Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
DiscrpAgID (type: esriFieldTypeString, alias: Discrepancy Agency ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
AddCode (type: esriFieldTypeString, alias: Additional Code, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
AddDataURI (type: esriFieldTypeString, alias: Additional Data URI, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Uninc_Comm (type: esriFieldTypeString, alias: Unincorporated Community (A4), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ESN (type: esriFieldTypeString, alias: ESN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
MSAGComm (type: esriFieldTypeString, alias: MSAG Community Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
Post_Comm (type: esriFieldTypeString, alias: Postal Community Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Unknown: Unknown])
Building (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
Floor (type: esriFieldTypeString, alias: Floor, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
Room (type: esriFieldTypeString, alias: Room, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
Seat (type: esriFieldTypeString, alias: Seat, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
Addtl_Loc (type: esriFieldTypeString, alias: Additional Location Information, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
LandmkName (type: esriFieldTypeString, alias: Complete Landmark Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
Milepost (type: esriFieldTypeString, alias: Milepost, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
Place_Type (type: esriFieldTypeString, alias: Place Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [airport: A place from which aircrafts operate, such as an airport or heliport.], [arena: Enclosed area used for sports events.], [bank: Business establishment in which money is kept for saving, commercial purposes, is invested, supplied for loans, or exchanged.], ... 32 more ...)
Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Elevation (type: esriFieldTypeInteger, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [CA: Canada], [US: United States of America], [FR: France])
County (type: esriFieldTypeString, alias: County or Equivalent (A2), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [MV: Metro Vancouver])
Effective (type: esriFieldTypeDate, alias: Effective Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Expire (type: esriFieldTypeDate, alias: Expire Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AK: Alaska], [AL: Alabama], [AR: Arkansas], ... 69 more ...)
Placement (type: esriFieldTypeString, alias: Placement Method, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Geocoding: Placement of an address point to represent an address along a road segment based on the high and low numbers assigned to the road segment using geocoding techniques.], [Parcel: Placement of an address point to represent an address associated with a parcel.], [PropertyAccess: Placement of an address point to represent an address based on the location of the primary access to a given property.], ... 3 more ...)
LSt_PreDir (type: esriFieldTypeString, alias: Legacy Street Name Pre Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
LSt_Name (type: esriFieldTypeString, alias: Legacy Street Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
LSt_Typ (type: esriFieldTypeString, alias: Legacy Street Name Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
LSt_PosDir (type: esriFieldTypeString, alias: Legacy Street Name Post Directional, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
PostCodeEx (type: esriFieldTypeString, alias: Postal Code Extension, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
NGUID (type: esriFieldTypeString, alias: NGUID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
DateUpdate (type: esriFieldTypeString, alias: Date Updated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Inc_Muni: Port Moody
Province: BC
pointtype: Unknown
currentstatus: 6
autogenvalue: 0
DiscrpAgID: portmoody.ca
AddCode: 915043
Post_Comm: Unknown
Country: CA
County: MV
State: BC
Placement: PropertyAccess

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Site_Structure_Address_Point)

Layers:

Layer: SiteStructureAddressPoint (0)