{"id":24123,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/geospatial-setup-1\/"},"modified":"2025-03-06T10:26:06","modified_gmt":"2025-03-06T18:26:06","slug":"geospatial-setup-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/","title":{"rendered":"Geospatial Setup"},"content":{"rendered":"<p><a href=\"v25\/geospatial-reports-1\/\">Click here for end user documentation<\/a><\/p>\n<p>Geospatial reporting must understand which fields in your installation point to fields such as latitude and longitude.\u00a0 These fields are processed as a group so the link between which fields comprise addresses and the corresponding latitude and longitude must be defined.\u00a0 You may also have several fields that all have the same context, for example more than one field for latitude, or more than one field with the city name.\u00a0 Each field is defined with a global attribute which identifies the collection of fields that are used together.\u00a0 This is termed a GEO_GROUP and you may have any number of these.\u00a0 Typically, a GEO_GROUP will have most of these fields:<\/p>\n<ul>\n<li>Latitude<\/li>\n<li>Longitude<\/li>\n<li>Street Address<\/li>\n<li>City<\/li>\n<li>State and or County<\/li>\n<li>Zip or Postal Code<\/li>\n<li>Country<\/li>\n<li>Map Reliability Level &#8211; used to identify the lowest level at which an address is determined to be accurate<\/li>\n<li>Boundary Level &#8211; used to set a level for the address fields so that the correct order for data is known.\u00a0 E.g. Country &#8211;&gt; State &#8211;&gt; City &#8211;&gt; Zip Code.<\/li>\n<\/ul>\n<p>Any field with the correct display type may be used as part of your geospatial capture and reporting; your ExtraView installation is preconfigured with a set of suitable fields and values identified using the global attribute name of GEO_GROUP.<\/p>\n<p>You can create additional sets of fields and group these with the global GEO_GROUP attribute and providing your own name for each group.<\/p>\n<p>The ideal configuration is one where you use an address verification service to check addresses you enter.\u00a0 These services both validate an address and return the precise street-level geolocation of a verified address.\u00a0 Contact ExtraView Corp. for details if you require assistance configuring this feature &#8211; ExtraView Corp. can license this service on your behalf.\u00a0 Note it may not be available for all countries in the world.<\/p>\n<p>Built into ExtraView is a more straightforward means of deriving the latitude and longitude of an address that does not require the use of an address verification service.\u00a0 This provides geocoordinates to the city level internationally, and to the zip code level within the USA.\u00a0 Once configured, when you enter a complete or partial address into an issue, ExtraView can determine the closest latitude and longitude and automatically store these values within your issues, making them available for the generation of maps within reports.<\/p>\n<h3>Summary of Steps to Configure Geospatial Reporting<\/h3>\n<ol>\n<li>Load the geospatial data\n<ol>\n<li>Load Shapefile data if you intend to produce Shaded and Heatmap output &#8211; users will primarily use these for scheduled reports<\/li>\n<li>Load geospatial coordinate data &#8211; this will be used to geocode address data entered.\u00a0 The data supplied will geocode US data to the closest Zip code.\u00a0 Users utilize this data for the production of interactive heat maps.\u00a0 This step is not required if you will use an address verification service which geocodes your data to the street level<\/li>\n<\/ol>\n<\/li>\n<li>Setup the Data Dictionary fields with their global attributes.\u00a0 This is a required step<\/li>\n<li>Load list data &#8211; these lists are provided to reduce the effort of configuring data such as lists of Countries and Cities.\u00a0 This is an optional step<\/li>\n<li>Configure your layouts &#8211; place the fields you have configured onto the appropriate\u00a0<em>add<\/em> and\u00a0<em>edit<\/em> screen layouts.\u00a0 This is a required step<\/li>\n<\/ol>\n<h3>Loading Geospatial Data<\/h3>\n<p>In order to set up geospatial reporting, two types of data are provided.\u00a0 You may load one or both of these dependent upon your requirements.<\/p>\n<ul>\n<li><strong>Shapefiles<\/strong> &#8211; these files contain vector-based polygons that provide the outline of territories, such as the outline of Countries, States, Counties, etc.\u00a0 The shapefiles provided with ExtraView provide outlines of the Countries of the world, the States and Counties within the USA and the Provinces within Canada.\u00a0 Other shapefiles can be sourced and loaded.\u00a0 Shapefiles are used to generate shaded maps and heatmaps.\u00a0 These maps are ideal for reporting where the requirement is to generate Adobe PDFs which are distributed via the report scheduler.\u00a0 The maps may also be presented within user&#8217;s browsers.\u00a0 If you only want to produce interactive maps, shapefiles do not need to be loaded<\/li>\n<li><strong>Geospatial Coordinates<\/strong> &#8211; these files provide the latitude and longitude of locations.\u00a0 They are not required if you subscribe to an address verification service to validate addresses entered and to return the geocoordinates of the validated address.\u00a0 The files provided are used to return the geocoordinates of all major cities and major administrative areas within the world (States, Provinces or Countries), and the States, Cities and Zip Codes within the USA.\u00a0 When configured as described on this page, the geospatial coordinates provide the means to add the latitude and longitude to any issue from the address information that users enter.\u00a0 These coordinates are not accurate to the street level but are accurate enough for most reporting purposes.\u00a0 Additional geospatial coordinate files may be sourced and loaded for other parts of the world.<\/li>\n<\/ul>\n<h4>Loading Shapefile Data<\/h4>\n<p>The shapefile data supplied with ExtraView is loaded as follows. Additional data sourced for other locations is loaded into your database in the same manner as described here.\u00a0 The shapefile data provided is:<\/p>\n<ul>\n<li>Country outlines for all countries in the world<\/li>\n<li>Outlines of all States within the USA and Provinces within Canada<\/li>\n<li>Outlines of all Counties within States within the USA<\/li>\n<\/ul>\n<p>To load the data, a utility named populateShapeFiles is run externally to ExtraView as a Java application.\u00a0 This utility loads files that are contained in a subdirectory of the ExtraView directory named <code>WEB-INF\/data<\/code>.\u00a0 All files within this directory with an extension of <code>.shp<\/code> are loaded.\u00a0 The data supplied with ExtraView is in the directory named <code>WEB-INF\/data\/geoshapefiles<\/code>.\u00a0 There are a series of files, with the extensions <code>.dbf<\/code>, <code>.prj<\/code>, <code>.shp<\/code> and <code>.shx<\/code>.\u00a0 Each set of 4 files comprise a single shapefile.<\/p>\n<p>The populateShapeFiles utility takes these arguments:<\/p>\n<ul>\n<li><code>JAVA_HOME<\/code><\/li>\n<li><code>TOMCAT_HOME<\/code><\/li>\n<li><code>EV_BASE<\/code><\/li>\n<li>Optionally, the name of the directory under <code>WEB-INF\/data<\/code> where the script files are stored if you do not intend to use <code>geosshapefiles<\/code>.<\/li>\n<\/ul>\n<p>Any errors encountered while running the utility are communicated to the console as well as to the ExtraView application server log.<\/p>\n<p><u>Windows Example<\/u><\/p>\n<p class=\"rteindent1\">This example will load the data supplied with ExtraView and assumes that the environment variables <code>JAVA_HOME<\/code>, <code>TOMCAT_HOME <\/code>and <code>EV_BASE <\/code>have been set.<\/p>\n<p class=\"rteindent1\">Change your working directory to <code>%EV_BASE%\/data<\/code><\/p>\n<p class=\"rteindent1\">Enter the command:<\/p>\n<p class=\"rteindent1\"><code>populateShapeFiles.bat %JAVA_HOME% %TOMCAT_HOME% %EV_BASE%<\/code><\/p>\n<p><u>Linux Example<\/u><\/p>\n<p class=\"rteindent1\">This example will load the data supplied with ExtraView on a Linux server.<\/p>\n<p class=\"rteindent1\">Change your working directory to <code>$EV_BASE\/data<\/code><\/p>\n<p class=\"rteindent1\">Modify the script named <code>populateShapefiles.sh <\/code>and edit the <code>JAVA_HOME<\/code> and <code>TOMCAT_HOME<\/code> entries to point to the correct places on your server<\/p>\n<p class=\"rteindent1\">Enter the command:<\/p>\n<p class=\"rteindent1\"><code>.\/populateShapeFiles.sh EV_BASE [geospatial directory name]<\/code><\/p>\n<p class=\"rteindent1\"><code>EV_BASE<\/code> is the base location of ExtraView and <code>[geospatial directory name]<\/code> is the optional directory name for the files with geospatial information if the directory name is not <code>geoshapefiles<\/code>.<\/p>\n<h4>Loading Geospatial Coordinate Data<\/h4>\n<p>The geospatial coordinate data supplied with ExtraView is loaded as follows. Additional data sourced for other locations is loaded into your database in the same manner as described here.\u00a0 The geospatial data provided is:<\/p>\n<ul>\n<li>Country level data for all countries in the world<\/li>\n<li>Top administrative level within each country.\u00a0 For example, the geolocations for States in the USA, Provinces in Canada, and Counties in the United Kingdom<\/li>\n<li>Within the USA, geospatial coordinates for each County within each State<\/li>\n<li>Within the USA, geospatial coordinates for each Zip Code<\/li>\n<\/ul>\n<p>To load the data, a utility named populateGeospatialTables is run externally to ExtraView as a Java application.\u00a0 This utility executes scripts that are contained in a subdirectory of the ExtraView directory named <code>WEB-INF\/data<\/code>.\u00a0 All scripts within this directory in files with an extension of <code>.sql<\/code> are executed.\u00a0 These scripts may all be contained within a single zipped file (with the extension of <code>.zip<\/code>.\u00a0 The data supplied with the installation is in the directory and file named <code>WEB-INF\/data\/geoscripts\/geoscripts1.zip<\/code>.<\/p>\n<p>The populateGeospatialTables utility takes these arguments:<\/p>\n<ul>\n<li><code>JAVA_HOME<\/code><\/li>\n<li><code>TOMCAT_HOME<\/code><\/li>\n<li><code>EV_BASE<\/code><\/li>\n<li>Optionally, the name of the directory under <code>WEB-INF\/data<\/code> where the script files are stored if you do not intend to use <code>geoscripts<\/code>.<\/li>\n<\/ul>\n<p>Any errors encountered while running the utility are communicated to the console as well as to the ExtraView application server log.<\/p>\n<p><u>Windows Example<\/u><\/p>\n<p class=\"rteindent1\">This example will load the data supplied with ExtraView and assumes that the environment variables <code>JAVA_HOME<\/code>, <code>TOMCAT_HOME <\/code>and <code>EV_BASE <\/code>have been set.<\/p>\n<p class=\"rteindent1\">Change your working directory to <code>%EV_BASE%\/data<\/code><\/p>\n<p class=\"rteindent1\">Enter the command:<\/p>\n<p class=\"rteindent1\"><code>populateGeospatialTables.bat %JAVA_HOME% %TOMCAT_HOME% %EV_BASE%<\/code><\/p>\n<p><u>Linux Example<\/u><\/p>\n<p class=\"rteindent1\">This example will load the data supplied with ExtraView on a Linux server.<\/p>\n<p class=\"rteindent1\">Change your working directory to <code>$EV_BASE\/data<\/code><\/p>\n<p class=\"rteindent1\">Modify the script named <code>populateGeospatialTables.sh <\/code>and edit the <code>JAVA_HOME<\/code> and <code>TOMCAT_HOME<\/code> entries to point to the correct places on your server<\/p>\n<p class=\"rteindent1\">Enter the command:<\/p>\n<p class=\"rteindent1\"><code>.\/populateGeospatialTables.sh EV_BASE [geospatial directory name]<\/code><\/p>\n<p class=\"rteindent1\"><code>EV_BASE<\/code> is the base location of ExtraView and <code>[geospatial directory name]<\/code> is the optional directory name for the files with geospatial information if the directory name is not <code>geoscripts<\/code>.<\/p>\n<h3>Geospatial Global Attribute Definitions<\/h3>\n<p>As stated above, your ExtraView configuration is preconfigured to work with geospatial reports.\u00a0 You may define additional groups of fields for geospatial working within your site or you may alter the default configuration provided.\u00a0 For example, you might define different GEO_GROUPS for different tracking applications in different Business Areas and Projects within your installation or you may want to alter the default GEO_GROUP name (which is GEO_GROUP).<\/p>\n<table style=\"width: 95%;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\n<tbody>\n<tr style=\"background-color: #eee;\">\n<td><strong>Attribute<\/strong><\/td>\n<td width=\"50\"><strong>Field Type<\/strong><\/td>\n<td><strong>Purpose<\/strong><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">GEO_GROUP<\/td>\n<td valign=\"top\">&#8212;<\/td>\n<td valign=\"top\">The name of the group of attributes that collectively define the information required to save geocoded information.\u00a0 All attributes within a group must have the same name.\u00a0 This allows you to define any number of groups for different purposes, with each group pointing to different fields for latitude, longitude, etc.\u00a0 Examples of names are GEO_GROUP (the preconfigured group name), MY_GEO_GROUP, or NORTH_AMERICA_GEO_INFO.\u00a0 This attribute name is placed on all the fields that form a group.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">GEO_LATITUDE<\/td>\n<td valign=\"top\">Decimal<\/td>\n<td valign=\"top\">This attribute is placed on the field that contains the latitude of the address for the GEO_GROUP<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">GEO_LONGITUDE<\/td>\n<td valign=\"top\">Decimal<\/td>\n<td valign=\"top\">This attribute is placed on the field that contains the longitude of the address <span style=\"background-color: transparent; color: #333333; display: inline; float: none; font-family: Arial,Verdana,Helvetica,sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;\">for the GEO_GROUP<\/span><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">GEO_RELIABILITY_LEVEL<\/td>\n<td valign=\"top\">List or<br \/>\nText field<\/td>\n<td>Depending on the source of the geocoding information (anywhere from manual entry to automated lookup of latitude and longitude) ExtraView may detect that the information entered is inaccurate.\u00a0 For example, you might try to enter a latitude and longitude for an address in the State of California and the geo coordinates you provide are obviously in a different part of the USA or different part of the world.\u00a0 ExtraView can determine the most reliable level of the data.<br \/>\nFor example, if the geo coordinates are in New York and the address entered states that it&#8217;s in California, the reliability level will be the Country level of the USA.\u00a0 Similarly, if you enter an address which states that a City&#8217;s name is in the state of California, but no such City name exists, the reliability level will be set to the State level.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">GEO_ADMIN_BOUNDARY_LEVEL<\/td>\n<td valign=\"top\">&#8212;<\/td>\n<td valign=\"top\">This attribute provides the level of the data for the field within which it&#8217;s defined.\u00a0 For example, the field which contains the values for the Country will most probably have a GEO_ADMIN_BOUNDARY_LEVEL of GEO_ADMIN_BOUNDARY_LEVEL1 and the field that contains the values for the State will have a GEO_ADMIN_BOUNDARY_LEVEL of GEO_ADMIN_BOUNDARY_LEVEL2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Optional List Values<\/h3>\n<p>Whilst any of the fields you use to hold address data may be text or list-based, it is common to use list type fields for shorter lists such as Country names or State names.\u00a0 ExtraView provides data for a number of lists, and you may create user defined fields and load the data supplied into these fields.\u00a0 These lists are in the English language.<\/p>\n<p>The step itemized above, to load geospatial coordinate data can be complemented by utilizing field lists within your ExtraView installation that contain data such as Country names and State names.\u00a0 To load any of these fields with data, create a list or pop-up list field within the data dictionary, and use the\u00a0<strong>Import Field Values<\/strong> button within any of the fields to load one or more of the following lists.\u00a0 These lists may be loaded into separate fields or combined together in any different combination of fields.<\/p>\n<table style=\"width: 100%;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\n<tbody>\n<tr style=\"background-color: #eee;\">\n<td><strong>Location of Data<\/strong><\/td>\n<td><strong>Purpose<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/countries.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the full names of the Countries in the World<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top; white-space: nowrap;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/countries-iso-alpha-2.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the\u00a0ISO 3166-1 alpha-2 character abbreviations of the Countries in the World<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/<span style=\"color: #aa0000; font-family: courier;\">countries-iso-alpha-3.txt<\/span><\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the ISO 3166-1 alpha-3 character abbreviations of the Countries in the World<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/au-states.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the States and Territories of Australia<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/ca-provinces.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the Provinces and Territories within Canada<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/cn-divisions.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the Divisions of China<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/de-states.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the States witrhin Germany<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/es-provinces.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the Provinces and Municipalities in Spain<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/fr-regions.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the Regions of France<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/it-regions.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the Regions of Italy<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/ja-prefectures.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the Prefectures of Japan<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/nz-regions.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the Regions within New Zealand<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/uk-counties.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the Counties within the United Kingdom<\/td>\n<\/tr>\n<tr>\n<td style=\"vertical-align: top;\"><span style=\"color: #aa0000; font-family: courier;\">WEB-INF\/data\/us-states.txt<\/span><\/td>\n<td style=\"vertical-align: top;\">A list of the 50 States plus the District of Columbia within the United States of America<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Example Configuration<\/h3>\n<h4 class=\"rteindent1\">Step 1<\/h4>\n<p class=\"rteindent1\">Within the data dictionary search for and edit the field named MAP_RELIABILITY_LEVEL.\u00a0 This field should be configured as follows:<\/p>\n<table style=\"width: 600px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\n<tbody>\n<tr>\n<td width=\"100\"><\/td>\n<td style=\"background-color: #eee;\"><strong>Property<\/strong><\/td>\n<td style=\"background-color: #eee;\"><strong>Value<\/strong><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Multiple Value<\/td>\n<td>No<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Allow selection on reports<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Filter Criteria<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Is sortable<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Add a Global Attribute of GEO_GROUP<\/td>\n<td>GEO_GROUP<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Add\u00a0 the Global Attribute of GEO_RELIABILITY_LEVEL<\/td>\n<td>&#8212;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"rteindent1\">The field list values should be examined, and if necessary the titles may be altered for your configuration.\u00a0 The predefined values are:<\/p>\n<table style=\"width: 600px;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\n<tbody>\n<tr>\n<td width=\"100\"><\/td>\n<td style=\"background-color: #eee;\"><strong>Value<\/strong><\/td>\n<td style=\"background-color: #eee;\"><strong>Sort Order<\/strong><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Country<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>State \/ Province<\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>County<\/td>\n<td>3<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>City<\/td>\n<td>4<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Zip \/ Postal Code<\/td>\n<td>5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 class=\"rteindent1\">Step 2<\/h4>\n<p class=\"rteindent1\">In the data dictionary edit the field named LATITUDE.\u00a0 It should be configured as follows:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"100\"><\/td>\n<td bgcolor=\"#eee\"><strong>Property<\/strong><\/td>\n<td bgcolor=\"#eee\"><strong>Value<\/strong><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Field Name<\/td>\n<td>LATITUDE<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Field Title<\/td>\n<td>Latitude<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Display Type<\/td>\n<td>Decimal<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Allow selection on reports<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Filter Criteria<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Is sortable<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Global Attribute of GEO_GROUP<\/td>\n<td>GEO_GROUP<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Global Attribute of GEO_LATITUDE<\/td>\n<td>&#8212;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 class=\"rteindent1\">Step 3<\/h3>\n<p class=\"rteindent1\">In the data dictionary edit the field named LONGITUDE.\u00a0 It should be configured as follows:<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"100\"><\/td>\n<td bgcolor=\"#eee\"><strong>Property<\/strong><\/td>\n<td bgcolor=\"#eee\"><strong>Value<\/strong><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Field Name<\/td>\n<td>LONGITUDE<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Field Title<\/td>\n<td>Longitude<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Display Type<\/td>\n<td>Decimal<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Allow selection on reports<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Filter Criteria<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Is sortable<\/td>\n<td>Yes<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Global Attribute of GEO_GROUP<\/td>\n<td>GEO_GROUP<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Global Attribute of GEO_LONGITUDE<\/td>\n<td>&#8212;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4 class=\"rteindent1\">Step 4<\/h4>\n<p class=\"rteindent1\">If they do not already exist, create your own user defined fields in the data dictionary that hold data for the <em>Country<\/em>, <em>State\/Province<\/em>, <em>County<\/em>, <em>City <\/em>and<em> Zip\/Postal Code<\/em>.\u00a0 These correspond to the values created in Step 1.\u00a0 Frequently you will not require all of these fields.\u00a0 For example, it is common within the United States not to use <em>County<\/em> as part of the address.\u00a0 Configure the properties and permissions for these fields as necessary.\u00a0 The fields may be one of the following display types:<\/p>\n<ul>\n<li class=\"rteindent1\">Text<\/li>\n<li class=\"rteindent1\">List<\/li>\n<li class=\"rteindent1\">Pop-up<\/li>\n<\/ul>\n<p class=\"rteindent1\">&gt;It is typically more convenient to configure fields with shorter amounts of text as List or Pop-up types and fields with more data as Text fields.\u00a0 For example, <em>Country<\/em> is often configured as a List field and an <em>Address <\/em>field is usually configured as a text field.\u00a0 You may use one or more of the optional sets of list values to pre-load values into List and Pop-up list fields.<\/p>\n<p class=\"rteindent1\">Add a global attribute for the GEO_GROUP name, which in our example is GEO_GROUP.\u00a0 Add the GEO_ADMIN_BOUNDARY_LEVEL global attributes as follows:<\/p>\n<table style=\"width: 95%;\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\n<tbody>\n<tr>\n<td width=\"100\"><\/td>\n<td style=\"background-color: #eee;\"><strong>Example Field Name<\/strong><\/td>\n<td style=\"background-color: #eee;\"><strong>GEO_GROUP<\/strong><\/td>\n<td style=\"background-color: #eee;\"><strong>GEO_ADMIN_BOUNDARY_LEVEL<\/strong><\/td>\n<td style=\"background-color: #eee;\"><strong>GEO_RELIABILITY_LEVEL<\/strong><\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>COUNTRY_NAME<\/td>\n<td>GEO_GROUP<\/td>\n<td class=\"rtecenter\">2<\/td>\n<td>Country<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>STATE_NAME<\/td>\n<td>GEO_GROUP<\/td>\n<td class=\"rtecenter\">3<\/td>\n<td>State \/ Province<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>CITY_NAME<\/td>\n<td>GEO_GROUP<\/td>\n<td class=\"rtecenter\">4<\/td>\n<td>City<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>POST_CODE<\/td>\n<td>GEO_GROUP<\/td>\n<td class=\"rtecenter\">4<\/td>\n<td>Zip \/ Postal Code<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"rteindent1\">Note that the GEO_ADMIN_BOUNDARY_LEVEL values do not correspond to the sort order of the values for the MAP_RELIABILITY_LEVEL values.\u00a0 First, the GEO_ADMIN_BOUNDARY_LEVEL value of 1 is defined as the level for the World.\u00a0 Secondly, when generating shaded maps and heat maps, ExtraView is only prepopulated with maps for the countries of the world, states and provinces of the USA and Canada, and counties of the USA.\u00a0 An interactive map of the world allows users to zoom in to street level from a map of the entire globe.<\/p>\n<p class=\"rteindent1\">When adding the global attribute for the GEO_ADMIN_BOUNDARY_LEVEL, you set the Field property to the name of the MAP_RELIABILTY_LEVEL field.\u00a0 In our example, this is also\u00a0MAP_RELIABILTY_LEVEL.\u00a0 The field value is set to the value in the above table.\u00a0 Note that both the City name and the Post Code share the same GEO_ADMIN_BOUNDARY_LEVEL.\u00a0 This is because the shapefiles loaded with the above <code>populateShapeFiles<\/code> utility does not contain maps with City boundaries but contains maps at the Zip code level.<\/p>\n<h4 class=\"rteindent1\">Step 5<\/h4>\n<p class=\"rteindent1\">Place the fields on the <em>add<\/em> or <em>edit<\/em> layout where you want the information to be geocoded.\u00a0 These fields will be:<\/p>\n<ul>\n<li class=\"rteindent1\">LATITUDE &#8211; you may hide this field on the layout, but this is where the latitude of the location you are geocoding will reside<\/li>\n<li class=\"rteindent1\">LONGITUDE &#8211; you may hide this field on the layout, but this is where the longitude of the location you are geocoding will reside<\/li>\n<li class=\"rteindent1\">MAP_RELIABILITY_LEVEL &#8211; you may hide this field on the layout, but this is where the map reliability level value of the location you are geocoding will reside<\/li>\n<li class=\"rteindent1\">According to your configuration, place the fields that define the following on your layout:\n<ul>\n<li class=\"rteindent1\">Country<\/li>\n<li class=\"rteindent1\">State \/ Province<\/li>\n<li class=\"rteindent1\">County<\/li>\n<li class=\"rteindent1\">City<\/li>\n<li class=\"rteindent1\">Zip \/ Postal Code<\/li>\n<\/ul>\n<\/li>\n<li class=\"rteindent1\">An optional step that allows the user to view the location on an interactive map is to define and embed a Geospatial Report within the <em>add<\/em> or <em>edit<\/em> screen.\u00a0 Please view the instructions on embedded reports for this.<\/li>\n<\/ul>\n<p class=\"rteindent1\">At the end of the day, the configuration may present similar to this to the end user:<\/p>\n<p class=\"rteindent1\"><img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ag\/workflow\/geo-screen.png\" alt=\"\" \/><\/p>\n<h3>Multiple GEO_GROUP Configuration<\/h3>\n<p>This allows you to defined multiple, independent groups of fields where each group has completely independent working within a single ExtraView installation.\u00a0 For example, you might have one group that is used to map customer issues, while a second group might map the location of all your organization&#8217;s stores.<\/p>\n<p>Each group must have its own set of fields as stated here.\u00a0 For the MAP_RELIABILITY_LEVEL, you may create an alias of the MAP_RELIABILITY_LEVEL field.<\/p>\n<p><a href=\"v25\/geospatial-reports-1\/\">Click here for end user documentation<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Click here for end user documentation Geospatial reporting must understand which fields in your installation point to fields such as latitude and longitude.\u00a0 These fields are processed as a group so the link between which fields comprise addresses and the corresponding latitude and longitude must be defined.\u00a0 You may also have several fields that all&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24123","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Geospatial Setup - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Geospatial Setup - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Click here for end user documentation Geospatial reporting must understand which fields in your installation point to fields such as latitude and longitude.\u00a0 These fields are processed as a group so the link between which fields comprise addresses and the corresponding latitude and longitude must be defined.\u00a0 You may also have several fields that all...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-06T18:26:06+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/\",\"name\":\"Geospatial Setup - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-03-06T18:26:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Geospatial Setup\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Geospatial Setup - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/","og_locale":"en_US","og_type":"article","og_title":"Geospatial Setup - Product Documentation","og_description":"Click here for end user documentation Geospatial reporting must understand which fields in your installation point to fields such as latitude and longitude.\u00a0 These fields are processed as a group so the link between which fields comprise addresses and the corresponding latitude and longitude must be defined.\u00a0 You may also have several fields that all...","og_url":"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-03-06T18:26:06+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/","url":"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/","name":"Geospatial Setup - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-03-06T18:26:06+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/geospatial-setup-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"Geospatial Setup"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24123"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24123\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}