Understanding Recognized Patterns and Data Enrichments

When you create a transform, Oracle Big Data Preparation Cloud Service automatically recognizes some patterns in the data. It also suggests enrichments that you can add based on the existing data.

Recognized Patterns

This list shows the patterns that are recognized when you create a transform. For more information on creating transforms, see Creating Transforms.

• Identifiers

• Codes

• Yes/no Flags

• Dates

• Quantities

• Free form text

• Social security numbers

• Credit Card Numbers

• Country codes

• Locale/Language Codes

• Email Addresses

• IP Addresses

• URLs

• US Phone Numbers

• US State Codes

• US Zip Codes

• Gender Codes

Data Enrichments

This list shows the data enrichments that are suggested when you create a transform. For information on how to apply data enrichments, see Enriching Data Sets.

• Country

• Province or State

• Jurisdiction (county)

• Population

• Elevation (in meters)

• Time Zone

• Longitude

• Latitude

• ISO Country Codes

• FIPS

• Country Name

• Capital

• Continent

• Population

• Spoken Languages

• Phone Country Code

• Postal Code Format

• Postal Code Regex

• Currency Name and Abbreviation

• TLD

• Surface

• GeoName ID

Geographical Enrichments

This list shows additional data enrichments based on geographical location that are suggested when you create a transform:

• abandoned_airfield

• abandoned_camp

• abandoned_canal

• abandoned_factory

• abandoned_farm

• abandoned_mine

• abandoned_mission

• abandoned_oil_well

• abandoned_police_post

• abandoned_populated_place

• abandoned_prison

• abandoned_railroad

• abandoned_railroad_station

• abandoned_railroad_stop

• abandoned_watercourse

• abandoned_well

• administrative_division

• administrative_facility

• agricultural_colony

• agricultural_facility

• agricultural_reserve

• agricultural_school

• airbase

• airfield

• airport

• amphitheater

• amusement_park

• anabranch

• anchorage

• ancient_road

• ancient_wall

• apron

• aquaculture_facility

• aqueduct

• arch

• archaeological_prehistoric_site

• arctic_land

• area

• arrugado

• artificial_island

• artillery_range

• asphalt_lake

• astronomical_station

• asylum

• athletic_field

• atolls

• atomic_center

• automatic_teller_machine

• badlands

• baling_station

• bank

• banks

• bar

• barracks

• basin

• battlefield

• bay

• bays

• beach

• beach_ridge

• beaches

• beacon

• bench

• bights

• blowholes

• blowouts

• boatyard

• body_of_water

• bogs

• border_post

• borderland

• boulder_field

• boundary_marker

• breakwater

• brewery

• bridge

• buffer_zone

• buildings

• burial_caves

• bus_station

• bus_stop

• bushes

• business_center

• buttes

• cairn

• caldera

• camps

• canal

• canal_bend

• canal_tunnel

• canalized_stream

• cannery

• canyon

• canyons

• cape

• capital_of_a_political_entity

• caravan_route

• casino

• castle

• cattle_dipping_tank

• causeway

• caves

• cemetery

• channel

• chrome_mines

• church

• cirque

• cirques

• city

• clearing

• clefts

• cliffs

• clinic

• coal_mines

• coalfield

• coast

• coast_guard_station

• coconut_grove

• college

• common

• communication_center

• community_center

• concession_area

• cones

• confluence

• continent

• continental_rise

• convent

• copper_mines

• copper_works

• coral_reefs

• cordillera

• corrals

• corridor

• country_house

• courthouse

• coves

• crater_lake

• crater_lakes

• craters

• cuestas

• cultivated_area

• current

• customs_house

• customs_post

• cutoff

• dairy

• dam

• deep

• delta

• dependent_political_entity

• depressions

• desert

• destroyed_populated_place

• dike

• diplomatic_facility

• dispensary

• distributary_ies

• ditch

• ditch_mouths

• divide

• docking_basin

• docks

• dockyard

• drainage_basin

• drainage_canal

• drainage_ditch

• dry_dock

• dry_stream_bed

• dunes

• economic_region

• escarpment

• escarpment_or_scarp

• estates

• estuary

• experiment_station

• facility

• facility_center

• factory

• fan

• fans

• farm

• farm_village

• farms

• farmstead

• ferry

• fields

• fifth_order_administrative_division

• first_order_administrative_division

• fishing_area

• fishponds

• fissure

• fjord

• flat

• ford

• forest_reserve

• forest_station

• forests

• former_sugar_mill

• fort

• fossilized_forest

• foundry

• fourth_order_administrative_division

• fracture_zone

• free_trade_zone

• freely_associated_state

• fuel_depot

• furrow

• gap

• gardens

• gas_oil_separator_plant

• gasfield

• gate

• geographical_spot

• geological_formation

• geyser

• ghat

• glaciers

• gold_mines

• golf_course

• gorges

• grassland

• grave

• gravel_area

• grazing_area

• guest_house

• gulf

• gully

• halting_place

• hammocks

• hanging_valley

• harbors

• headland

• headwaters

• heath

• heliport

• hermitage

• hill

• hills

• historical_administrative_division

• historical_capital_of_a_political_entity

• historical_first_order_administrative_division

• historical_fourth_order_administrative_division

• historical_political_entity

• historical_populated_place

• historical_region

• historical_second_order_administrative_division

• historical_site

• historical_third_order_administrative_division

• hole

• homestead

• hospital

• hot_springs

• hotel

• houses

• housing_development

• hunting_reserve

• hut

• huts

• hydroelectric_power_station

• icecap

• icecap_depression

• icecap_dome

• icecap_ridge

• independent_political_entity

• industrial_area

• inlet

• inspection_station

• interdune_troughs

• interfluve

• intermittent_lake

• intermittent_lakes

• intermittent_oxbow_lake

• intermittent_pond

• intermittent_ponds

• intermittent_pool

• intermittent_reservoir

• intermittent_salt_lake

• intermittent_salt_ponds

• intermittent_stream

• intermittent_wetland

• iron_mines

• irrigated_fields

• irrigation_canal

• irrigation_ditch

• irrigation_system

• island

• islands

• islet

• israeli_settlement

• isthmus

• jetty

• karst_area

• knoll

• knolls

• labor_camp

• lagoon

• lagoons

• lake

• lake_beds

• lake_channels

• lake_region

• lakes

• land_tied_island

• landfill

• landing

• language_school

• lava_area

• leased_area

• ledge

• leper_colony

• leprosarium

• levee

• library

• lighthouse

• limekiln

• local_government_office

• locality

• locks

• logging_camp

• lost_river

• mall

• maneuver_area

• mangrove_island

• mangrove_swamp

• marina

• marine_channel

• maritime_school

• market

• marshes

• meadow

• meander_neck

• medical_center

• mesa

• mesas

• meteorological_station

• metro_station

• military_base

• military_installation

• military_school

• mills

• mines

• mining_area

• mining_camp

• mission

• moat

• mole

• monastery

• monument

• moors

• moraine

• mosque

• mound

• mounds

• mountain

• mountains

• mud_flats

• munitions_plant

• museum

• narrows

• nature_reserve

• naval_base

• navigation_canals

• navigation_channel

• novitiate

• nunatak

• nunataks

• nursery_ies

• oasis_es

• observation_point

• observatory

• ocean

• office_building

• oil_camp

• oil_palm_plantation

• oil_pipeline

• oil_pipeline_junction

• oil_pipeline_terminal

• oil_pumping_station

• oil_refinery

• oil_well

• oilfield

• olive_grove

• olive_oil_mill

• opera_house

• orchards

• ore_treatment_plant

• overfalls

• oxbow_lake

• pagoda

• palace

• palm_grove

• palm_tree_reserve

• pan

• pans

• parish

• park

• park_gate

• park_headquarters

• park_or_area

• parking_lot

• pass

• patrol_post

• peak

• peaks

• peat_cutting_area

• peninsula

• petroleum_basin

• phosphate_works

• pier

• pine_grove

• pinnacle

• plain

• plains

• plateau

• point

• points

• polder

• police_post

• political_entity

• political_region

• pond

• ponds

• pools

• populated_locality

• populated_place

• populated_places

• port

• portage

• post_office

• power_station

• prison

• promenade

• promontory_ies

• province

• pyramid

• pyramids

• quarry_ies

• quay

• quicksand

• racetrack

• radio_observatory

• radio_station

• railroad

• railroad_junction

• railroad_siding

• railroad_signal

• railroad_station

• railroad_stop

• railroad_tunnel

• railroad_yard

• ranches

• rapids

• ravines

• reach

• reef

• reefs

• reformatory

• refugee_camp

• region

• religious_center

• religious_populated_place

• religious_site

• research_institute

• reservation

• reserve

• reservoirs

• resort

• restaurant

• resthouse

• retreat

• ridge

• ridges

• rise

• road

• road

• road_bend

• road_cut

• road_junction

• road_tunnel

• roadstead

• rock

• rock_desert

• rockfall

• rocks

• rookery

• rubber_plantation

• ruined_bridge

• ruined_dam

• ruins

• sabkhas

• saddle

• salt_area

• salt_evaporation_ponds

• salt_lake

• salt_lakes

• salt_marsh

• salt_mines

• salt_pond

• salt_ponds

• sanatorium

• sand_area

• sandy_desert

• satellite_station

• sawmill

• school

• scientific_research_base

• scrubland

• sea

• seachannel

• seachannels

• seamount

• seamounts

• seaplane_landing_area

• seat_of_a_first_order_administrative_division

• seat_of_a_fourth_order_administrative_division

• seat_of_a_second_order_administrative_division

• seat_of_a_third_order_administrative_division

• seat_of_government_of_a_political_entity

• second_order_administrative_division

• section_of_bank

• section_of_canal

• section_of_estate

• section_of_harbor

• section_of_independent_political_entity

• section_of_intermittent_stream

• section_of_island

• section_of_lagoon

• section_of_lake

• section_of_peninsula

• section_of_plain

• section_of_plateau

• section_of_populated_place

• section_of_reef

• section_of_stream

• section_of_valley

• section_of_wadi

• section_of_waterfalls

• semi_independent_political_entity

• sewage_treatment_plant

• sheepfold

• shelf

• shelf_edge

• shelf_valley

• shoal

• shoals

• shore

• shrine

• sill

• sinkhole

• slide

• slope

• slopes

• sluice

• snowfield

• sound

• spa

• space_center

• spillway

• spit

• springs

• spur

• spurs

• square

• stable

• stadium

• state_exam_prep_center

• steps

• stock_route

• stony_desert

• store

• storehouse

• strait

• stream

• stream_bank

• stream_bend

• stream_mouths

• streams

• street

• sub_surface_dam

• sugar_mill

• sugar_plantation

• sugar_refinery

• sulphur_springs

• swamp

• tablemount_or_guyot

• tablemounts_or_guyots

• talus_slope

• tank_farm

• tea_plantation

• technical_school

• temp_work_office

• temples

• terrace

• territory

• theater

• third_order_administrative_division

• tidal_creeks

• tidal_flats

• tombs

• tongue

• tower

• traffic_circle

• trail

• transit_terminal

• trees

• trench

• triangulation_station

• tribal_area

• trough

• tundra

• tunnel

• underground_irrigation_canals

• underground_lake

• undersea_formation

• united_states_government_establishment

• university

• university_prep_school

• upland

• valley

• valleys

• veterinary_facility

• vineyard

• vineyards

• volcano

• wadi

• wadi_bend

• wadi_junction

• wadi_mouth

• wadies

• wall

• water_mill

• water_pumping_station

• water_tank

• watercourse

• waterfalls

• waterholes

• waterworks

• weirs

• well

• wells

• wetland

• whaling_station

• wharf_ves

• whirlpool

• wildlife_reserve

• windmill

• woodland

• wreck

• zone

• zoo