The “Location Extractor” node allows to extract geographic locations from unstructured English text. This node uses Palladian’s location extraction mechanism.
The location extraction algorithm performs various steps for recognizing potential locations within a given text, followed by a disambiguation. The disambiguation step checks hierarchical/contains relations and identifies correct locations by their proximity to other given locations in the text.
Each identified location in the text is returned, multiple occurrences are returned as often as they occur. Extracted locations are classified into the following categories:
- CONTINENT (e.g. “Asia”)
- COUNTRY (e.g. “Japan”)
- CITY (e.g. “Tokyo”)
- ZIP (ZIP code of a city)
- STREET (name of a street)
- STREETNR (number of a building within a street)
- UNIT (a political or administrative unit like state, county, district)
- REGION (an area independent from or spanning multiple political or administrative units)
- POI (a human-made point of interest, like hotels, museums, universities, monuments, etc.)
- LANDMARK (geographic features like rivers, canyons, lakes, islands, waterfalls, etc.)
- UNDETERMINED (an undetermined or unknown type)
For each location, geographical coordinates with longitude and latitude values are provided. They are in WGS84 decimal degrees.
Location Source Setup
In order to use the “Location Extractor”, a “Location Source” (also known as Gazetteer) must be configured. The Location Source provides a database with real world locations and meta information such as alternative names, population figures, coordinates, and hierarchical relations. You can select and configure Location Sources in the KNIME Preferences under KNIME → Palladian → Location Extractor.
There are two Location Sources available:
GeoNames: We currently provide a freely usable Location Source for the GeoNames API. This Location Source allows 30,000 REST requests/day, 2,000 REST request/hour. To add the GeoNames source, click the “New…” button, and follow the instructions and the link to create a free GeoNames account. We suggest to enable the option to retrieve location hierarchies to improve the Location Extractor’s results. This however causes an additional API request for every found location.
Local Gazetteer: In case, you want to keep your data private, you’re running out of GeoName’s request limit, or you significantly want to speed up operations, we provide a separate plugin, which allows to setup a local gazetteer on your machine without accessing the Web. Contact us at mail@palladian.ai, if you are interested.
Options
Output Ports
- Table with rows for each extracted location from the provided text inputs. It provides columns with the normalized name of the location (e.g. the short form “L.A.” occurring in the text is returned by its full form “Los Angeles”), the type of the location, the geographical coordinates in WGS84 decimal degrees, and the population of the location (if applicable).
Popular Predecessors
- Math Formula5 %
Excel Reader (XLS)5 %- Color Manager4 %
Number To String4 %- Column Combiner3 %
Row Filter (deprecated)3 %- GroupBy3 %
- Chunk Loop Start3 %
Joiner3 %- Google Address Geocoder3 %
- Latitude/Longitude to Coordinate3 %
- Web Page Content Extractor3 %
- String Manipulation2 %
- Coordinate to Latitude/Longitude2 %
- HTML Node to Text2 %
Excel Reader (XLS)2 %- Excel Reader2 %
- Extract URI Info2 %
File Reader2 %- Partitioning2 %
- Missing Value2 %
XLS Reader2 %Reverse Location Lookup2 %- Domain Calculator2 %
CSV Reader1 %- Table Creator1 %
- k-Means1 %
- RowID1 %
- String Replacer1 %
- Cell Splitter1 %
- Missing Value Column Filter< 1 %
- Rule-based Row Filter< 1 %
- Java Snippet (simple)< 1 %
- Twitter Search< 1 %
- Java Snippet< 1 %
- Concatenate< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
FreeGeoIP< 1 %- Wait...< 1 %
- Try (Data Ports)< 1 %
- Column Auto Type Cast< 1 %
- Column Filter< 1 %
Column Rename< 1 %- Unpivot< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
Excel Reader (XLS)< 1 %- JSON Path< 1 %
- String to Date&Time< 1 %
- MapQuest Geocoder< 1 %
- HTML Parser< 1 %
- Chunk Loop Run-for-time Loop Start< 1 %
- String to URI< 1 %
Table Reader< 1 %- Group Loop Start< 1 %
- Cluster Assigner< 1 %
String To Number< 1 %- String to Number< 1 %
- Column Merger< 1 %
String To Number (PMML)< 1 %- String Splitter (Regex)< 1 %
- DB Query Reader< 1 %
- k-Medoids< 1 %
- Math Formula (Multi Column)< 1 %
- PDF Parser< 1 %
- Tika Parser< 1 %
- Dictionary Tagger< 1 %
- Table View (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Columns to JSON< 1 %
- Window Loop Start< 1 %
- Twitter Users< 1 %
Location Extractor< 1 %ReverseGeocoder< 1 %Regex Extractor< 1 %Web Searcher< 1 %- Duplicate Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Rule Engine< 1 %
- Distance Matrix Calculate< 1 %
Views
- This node has no views
Workflows
Links
- Selenium Nodes: How to scroll within a section?by qqilihq on 2021-03-20forum.knime.com/p/119029
- ERROR Google Address Geocoderby qqilihq on 2022-03-10forum.knime.com/p/150393
- Geographic visualization of author data from PubMed articlesby qqilihq on 2022-02-21forum.knime.com/p/148666
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.