Element Details: Geocode+Columns
 Back


Available in: Logi Info Source code name: GeocodeColumns

GeocodeColumns accepts an address and attempts to return latitude and longitude. The values are put into two columns that are added to the DataLayer: "Longitude" and "Latitude".

Specify the names of the columns already in the DataLayer that make up the address. Specify either a PlaceDataColumn with a full or partial address, or data columns for each of the address parts. All parts do not need to be included, for example specifying just StateProvinceDataColumn returns the location of the state capital. Specifying just a zip code returns the location of the zip code.

Element Group:GIS and Location Mapping



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
CityDataColumn
UserDefined
Enter the name of a column from the DataLayer that has the city name.
ConnectionID
UserDefined
Specifies a connection to a data source that is defined in the Settings. For elements connecting to relational databases, default is the first Connection element in _settings.lgx.
CountryDataColumn
UserDefined
Enter the name of a column from the DataLayer that has the contry name.
HouseNumberDataColumn
UserDefined
Enter the name of a column from the DataLayer that has street number.
ID
UserDefined
The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
IncludeCondition
True
False
An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped. Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript. Typically, you would compare values using an operator, such as "@Session.value~ < 0". Use quotes when working with strings: "@Session.myValue~" == "SomeValue"
LatitudeColumnID
UserDefined
The ID of the column that will be set to the latitude. The default value is "Latitude".
LongitudeColumnID
UserDefined
The ID of the column that will be set to the longitude. The default value is "Longitude".
PlaceDataColumn
UserDefined
Enter the name of a column from the DataLayer that has the address information or a place name in a single string. Use this attribute when the address is not broken up into parts. PlaceDataColumn works with certain partial addresses. Here are some examples: "Washington Monument" "22102" "McLean, VA" "Virginia" When this attribute is used, the other address DataColumn attributes are not used.
PostalCodeDataColumn
UserDefined
Enter the name of a column from the DataLayer that has the postal or ZIP code.
StateProvinceDataColumn
UserDefined
Enter the name of a column from the DataLayer that has the state, province or region name.
StreetDataColumn
UserDefined
Enter the name of a column from the DataLayer that has the street name.



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.Cached
DataLayer.CSV
DataLayer.Data Services
DataLayer.Definition List
DataLayer.Directory
DataLayer.ETL
DataLayer.Excel
DataLayer.Fixed Format File
DataLayer.Google App
DataLayer.Google Spreadsheet
DataLayer.JSON
DataLayer.LDAP
DataLayer.Linked
DataLayer.Mongo Find
DataLayer.Mongo Map Reduce
DataLayer.Mongo Run Command
DataLayer.Plugin
DataLayer.REST
DataLayer.SimpleDB
DataLayer.SP
DataLayer.SQL
DataLayer.Static
DataLayer.Twitter
DataLayer.Web Feed
DataLayer.Web Scraper
DataLayer.Web Service
DataLayer.XML


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top


 Chart Debug