0 ×

GeoIP2 Extractor

Palladian for KNIME: MaxMind Nodes version 2.4.0.202102162050 by palladian.ws

This node allows to extract various location-related information for given IP addresses via MaxMind’s GeoIP2 data, such a country, city, postal codes, coordinates, and various technical details. It supports IPv4 addresses (e.g. 1.2.3.4) and IPv6 addresses (e.g. 2001:db8::1:0:0:1; using the “canonical form” according to RFC 5952 is recommended, but any valid string representation is handled).

You can use the node with different data sources:

  • Using the “GeoIP2 WS Connector” node, you can access MaxMind’s REST API.
  • Using the “GeoIP2 DB Connector” node, you can work with a local version of the MaxMind database.

For more details, please check the corresponding nodes’ documentation.

Please note that (quoting from here): “IP geolocation is inherently imprecise. Locations are often near the center of the population. Any location provided by a GeoIP2 database or web service should not be used to identify a particular address or household.”

The selected “Response Type” determines the kind and granularity (i.e. columns) of data to return. The available Response Types on the other hand depend on the data source which is connected as input to this node. Currently, the following types are supported (for a fine-grained description of all fields please see here):

Response Type Explanation
Country Information about the continent, country, and the network in CIDR notation where the user of the IP address is located. See here for more details.
City Includes all information from “Country” and additional information about the city, zip code, metro code, time zone, latitude/longitude, accuracy, ISP/organization, domain and AS number. See here for more details.
Insights Includes all information from “City” and additional “insights”: Is IP used as an anonymizer, the type of anonymizer (e.g. proxy or VPN), is the IP static or dynamic, a user type classification (e.g. whether IP is used as “business, residence, cellular connection, traveler, government/military entity, and more”). See here for more details.
ASN Provides only information related to the autonomous system (i.e. ISP-related information) of the IP address.

Options

Input
Select the input column which contains the IP addresses.
Output Column Prefix (*)
Set a prefix for the appended column names.
Response Type
Select the type of data you want to extract (the available options depend on the data source which you connect to the node’s input).

Input Ports

Icon
Connector to the MaxMind data.
Icon
The input table which contains a column with IP addresses as string values.

Output Ports

Icon
Output table which contains the location-related information for the given IP addresses. The actual columns available depend on the selected “Response Type”. The last two columns contain raw GeoIP2 JSON result and error information (in case one occurred -- in this case all other columns contain missing values).

Installation

To use this node in KNIME, install Palladian for KNIME: MaxMind Nodes from the following update site:

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.