Utility Location

Entity

Name: Utility Location

The utility location is the physical location of a person or organization where a utility company supplies service.

Details

Table: Properties

Name General Data Type Oracle Data Type Relational Column Required? Primary Key? Validations Related Graph Object
utility location id string VARCHAR2 UTILITY_LOCATION_ID Yes Yes Must match regex pattern: ^\S{1,}$ ewok:Location.Utility
parent utility location id string VARCHAR2 PARENT_UTILITY_LOCATION_ID       ewok:Location.Utility
utility location type string VARCHAR2 UTILITY_LOCATION_TYPE     Must match values in enumerated list from graph core:ServiceLocationType
street address string VARCHAR2 STREET_ADDRESS       geo:StreetAddress
city string VARCHAR2 CITY       geo:StreetAddress
postal code string VARCHAR2 POSTAL_CODE     Must match regex pattern: [A-Z]{2}-\S{1,} geo:PostalCode
address county string VARCHAR2 ADDRESS_COUNTY       geo:StreetAddress
address region code string VARCHAR2 ADDRESS_REGION_CODE     Must match regex pattern: [A-Z]{2}-[A-Z]{2} geo:Subterritory
country code string VARCHAR2 COUNTRY_CODE     Must match values in enumerated list from graph geo:Country
street address type string VARCHAR2 STREET_ADDRESS_TYPE     Must match values in enumerated list from graph geo:PhysicalAddressType
latitude double NUMBER LATITUDE     Must match regex pattern: ^[+|-]?([1-8]?[0-9]|[1-9]0)\.{0,1}\d{1,10} geo:GeoPoint
longitude double NUMBER LONGITUDE     Must match regex pattern: ^[+|-]?([1]?[0-7][0-9]|[1]?[1-8][0]|[1-9]?[0-9])\.{0,1}\d{0,10} geo:GeoPoint