{"id":122191,"date":"2012-02-15T01:58:55","date_gmt":"2012-02-15T01:58:55","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/products\/product\/uncategorized\/drag-and-drop-part-2-making-pop-up-window-information-neater-and-more-presentable\/"},"modified":"2012-02-15T01:58:55","modified_gmt":"2012-02-15T01:58:55","slug":"drag-and-drop-part-2-making-pop-up-window-information-neater-and-more-presentable","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/product\/water\/drag-and-drop-part-2-making-pop-up-window-information-neater-and-more-presentable","title":{"rendered":"Drag and Drop Part 2 \u2013 Making Pop-up Window Information Neater and More Presentable"},"author":4911,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23051],"tags":[39071,39081,39091,39101,24981,39111,39121,39131],"industry":[],"product":[],"class_list":["post-122191","blog","type-blog","status-publish","format-standard","hentry","category-water","tag-aquatic-biology","tag-drag-and-drop","tag-fish","tag-fishnet","tag-hydro","tag-museum-records","tag-speckled-dace","tag-vertnet"],"acf":{"short_description":"Prepare the Data\n\nIn part 1 of this blog, we showed you how to take species observation data such as museum records with an x, y coordina...","flexible_content":[{"acf_fc_layout":"content","content":"

Prepare the Data<\/strong><\/span><\/p>\n

In part 1<\/a><\/strong> of this blog, we showed you how to take species observation data such as museum records with an x, y coordinate pair and drag and drop it into ArcGIS.com map to make a web map. We used data we downloaded from the Fishnet<\/a><\/strong> website to make a web mapping application showing records for Speckled Dace<\/a><\/strong>. <\/p>\n

Let’s say you click on a point in this map, what do you see? You see a simple list of attributes. It’s a start. But you have to scroll way down to see the important things like the collection date and the collector. Other values could use some clean up on the database side to make the map more presentable. For example, values for counties include “Benton County”, “Catron”, \u201cDOUGLAS\u201d and \u201cKittitas Co.\u201d while other records have no value for county at all.<\/p>\n

\"The\u00a0<\/p>\n

Figure 1: The original pop-up window from our Speckled Dace map.<\/em><\/p>\n

In version 2.0<\/a><\/strong> of our Speckled Dace map we used the field calculator in ArcMap to format the data a bit first before it goes into a pop-up window. To build this new map we downloaded the most recent version of the Fishnet<\/a><\/strong> query for Rhinichthys osculus and deleted records without coordinates. These data records sometimes contain commas in their fields, so we chose to download the tab-delimited format, *.txt. We imported the table to a geodatabase and added it to a new ArcMap document for editing.
\nSpecimen<\/strong><\/span><\/p>\n

The catalog number and museum code are used to refer to a particular specimen held by a specific institution in scientific publications. The catalog number is the key value that unlocks all sorts of information about a specimen, including notes kept by the collector and other related information.<\/p>\n

The original pop-up displayed the institution and catalog number separately because they are in two different fields. We think our map reader would like to see them together because they make more sense to our audience when read together like this:<\/p>\n

UWFC<\/a><\/strong> 029568<\/p>\n

The CatalogNumber field in the Speckled Dace dataset contains a variety of data: numbers, text plus numbers, and combinations of text, numbers and special characters. A second field, InstitutionCode, is relatively straightforward. InstitutionCode provides the standard code used to identify the museum that owns the specimen. This field is fully populated and needs no modification.<\/p>\n

\"Data\u00a0<\/p>\n

Figure 2: Data in the CatalogNumber field are in different formats and need to be standardized for the pop-up.<\/em><\/p>\n

To standardize the catalog number we first added a new field, CatNum, to the table as text format field and set its length to 20.<\/p>\n

As we mentioned the CatalogNumber field has data formatted different ways, including some records with their museum codes still attached. To remove the museum codes from the catalog numbers first right-click the CatNum field and then select field calculator.\u00a0 Then we use a simple Python function to split the CatalogNumber field and populate the CatNum field with the museum code removed.
\n\"Screen\u00a0<\/p>\n

Figure 3: Screen shot of the field calculator with Split_CatalogNumber.cal calculation file loaded.<\/em><\/p>\n

Note that the python parser radio button has been selected and there are two windows into which to place code, the pre-logic script code window, and the window below it where the field calculation is defined. Be sure when you do your calculation to check the Show Codeblock box, otherwise you will not see the pre-logic script code window.<\/p>\n

\"The\u00a0<\/p>\n

Figure 4: The data table after performing the calculation using the Split_CatalogNumber.cal calculation file.<\/em><\/p>\n

CatNum is now populated with the catalog number of each specimen and its museum code removed.<\/p>\n

We would like to provide a link from each record to the web page of the institution that provided the data. We can do that by joining a table of with hyperlinks in it to our original table. To add links we made a new table with fields that will contain the museum codes and hyperlinks.<\/p>\n

\"Figure<\/em><\/p>\n

Figure 5: Lookup table for adding links to museum web pages.<\/em><\/p>\n

Join the museum links table to the fishnet records using InstitutionCode field from the original table and MuseumCode from the museum link table.\u00a0 Next, export the joined table to make the join permanent. The extra MuseumCode and OBJECTID_1 fields may be deleted from the new table.<\/p>\n

We then made a new text field, Specimen, and set its length to 200. To create this field we will use field calculator (Specimen_html.cal) to merge the InstitutionCode, CatNum, and Link fields and add a hyperlink.<\/p>\n

The Specimen_html.cal calculation file does not use a python function so it only has the following code in the field calculation window:<\/p>\n

“<a href=”” + !Link! + “”> ” + !InstitutionCode! + “<\/a> ” + !CatNum!<\/p>\n

This concatenates the InstitutionCode, CatNum, and Link fields and adds a hyperlink with an HTML link tag.<\/p>\n

The new Specimen field is populated with values that look like this:<\/p>\n

<a href=”http:\/\/www.museum.tulane.edu\/”> TU<\/a> 93821<\/p>\n

Because ArcGIS.com understands the meaning of the HTML link tag, the field will display in the pop-up like this:<\/p>\n

TU<\/a><\/strong> 93821<\/p>\n

The museum code is now linked to the museum\u2019s webpage! The specimen field is now ready for the web map. Once this is all working properly you can place hyperlinks in your arcgis.com map pop-ups and have all kinds of information available to your map viewer without the needless clutter of dumping things unformatted into the pop-up window.<\/p>\n

Locality<\/strong><\/span><\/p>\n

In the original version of the Speckled Dace map, information about location of the record was split amongst three fields, StateProvince, County, and Locality.<\/p>\n

Raw values in the StateProvince field are both capitalized and un-capitalized. We could run a simple capitalization script, however some states such as North Dakota and New Mexico have two words in their names that need to be capitalized, so we recommend using a script to calculate this field so that everything comes out the way it should.\u00a0 This script is called State_caps.cal and is the following:<\/p>\n

State_caps.cal<\/p>\n

Pre-logic Script Code:<\/p>\n

\u00a0\u00a0\u00a0 def function(State):\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 final = “”\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 split =\u00a0 State.split()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 for word in split:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 caps = word.capitalize()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 final += caps + ” ”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 final = final.strip()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return final<\/p>\n

Field Calculation:
\n\u00a0\u00a0\u00a0 StateProvince = function(!StateProvince!)<\/p>\n

To run the calculation script we right-clicked the StateProvince field, selected field calculator, loaded and then ran the State_caps.cal script.<\/p>\n

Counties are even more complicated, some values end in \u201cCo.\u201d while others end in \u201ccounty\u201d.\u00a0 Still others are in Canada where the county field is not populated.\u00a0 The following County_Cleanup.cal script traps all these cases and standardizes the field:<\/p>\n

County_Cleanup.cal
\n\u00a0
\nPre-logic Script Code:
\n\u00a0\u00a0\u00a0 def function(county, state):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if county[-3:] == “Co.”:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return county[:-3] + ” County”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if county.find(“County”) == -1 and state != “British Columbia”:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return county + ” County”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return county<\/p>\n

Field Calculation:
\n\u00a0\u00a0\u00a0 County = function(!County!, !StateProvince!)
\n\"The\u00a0<\/p>\n

Figure 6: The County field before and after running the County_Cleanup.cal script. Note that the counties still have irregular capitalization.<\/em><\/p>\n

The last step for preparing the counties is to standardize capitalization. To do this we ran the County_caps.cal script which is very similar to the State_caps.cal script.<\/p>\n

County_caps.cal<\/p>\n

Pre-Logic Script Code:
\n\u00a0\u00a0\u00a0 def function(CountyCap):\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 final = “”\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 split =\u00a0 CountyCap.split()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 for word in split:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 caps = word.capitalize()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 final += caps + ” ”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 final = final.strip()
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return final<\/p>\n

Field Calculation:
\n\u00a0\u00a0\u00a0 County = function( !County! )<\/p>\n

To standardize the capitalization we used a second script (County_caps.cal) that is similar to the one used to fix the capitalization of the StateProvince field.
\n\u00a0<\/p>\n

\"Figure<\/em><\/p>\n

Figure 7: Final County field ready for use in web map.<\/em><\/p>\n

To organize the locality information contained in the StateProvince, County, and Locality fields into a single field we first need to tackle the case of records with no locality data. First we sorted the table so the fields with NULL values in their locality field are all in a row. Then we highlighted these records and used field calculator to populate them with the value \u201cx\u201d which a later script will change into \u201cNo locality information reported.\u201d<\/p>\n

We then cleared the selection and added a text field LocHTML and set its length to 250. We ran a field calculator script (Locality.cal) to assemble the three fields for the web map.<\/p>\n

Locality.cal<\/p>\n

Pre-logic Script Code:
\n\u00a0\u00a0\u00a0 def function(loc):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 length = len(loc)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if length > 200:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 loc = loc[:200] + “…”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if loc[-1:] != “.”:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 loc = loc + “.”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return loc<\/p>\n

\u00a0\u00a0\u00a0 def countyFunction(county):
\n\u00a0\u00a0 \u00a0 \u00a0\u00a0 if county == “x”:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 county = ” ”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 county = ” ” + county + “, ”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return county<\/p>\n

Field Calculation:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 function( !Locality! ) + countyFunction(!County!) + ( !StateProvince!) + “.”<\/p>\n

Because fields in a dbf file cannot be longer than 254 characters, the Locality.cal script trims Locality values greater than 200 characters, leaving space for the county and state. If the locality is clipped an ellipsis is added (\u201c\u2026\u201d) to indicate that more information is associated with the original record. Next if the Locality does not end in a period one is added. If the County field is = \u201cx\u201d a space is added to the end of the locality string otherwise a space followed by the County value then a comma and space are appended to the locality string. Lastly the state and a period are added yielding values that look like this:<\/p>\n

\u00a0\u00a0\u00a0 New Fork River 1.5 mi. W of Pinedale, US Hwy. 187. Sublette County, Wyoming.<\/p>\n

\u00a0\u00a0\u00a0 No locality information reported. Idaho.<\/p>\n

\u00a0\u00a0\u00a0 North Fork John Day River. Oregon.
\nCollection Date<\/strong><\/span><\/p>\n

In our original map the collection date is displayed in three rows, in a number format.\u00a0 Because using a number for the month can be confusing to international audiences, we wanted to convert the MonthCollected field to a text field instead of a number field.<\/p>\n

First we made a lookup table which contains the name of each month and the number of each month in two fields. We are going to concatenate some of these fields together, so we need to limit the lengths of each of the fields for right now. The Month field should be an integer, and the MonthText field should be a text field with a length of 40.
\n\"Lookup\u00a0<\/p>\n

Figure 8: Lookup table used to convert MonthCollected values from number to text.<\/em><\/p>\n

We then joined the new table\u2019s Month field to the original tables MonthCollected field. We exported the joined table to make the join permanent and then deleted the Month and OBJECTID_1 fields. We sorted the new table on the MonthText field and select null values. We used the field calculator to set the null values to “Collection date not provided” (this is why we made the field length = 40).
\nWe then added a new text field named Full_Date to the table and set its length to 40. We used the field calculator script Date.cal to assemble the month, day, and year for the web map.
\nDate.cal<\/p>\n

Pre-logic Script Code:
\n\u00a0\u00a0\u00a0 def function(month, day, year):
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if month == “None”:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 date = “Collection date not provided”
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 date = month + ” ” +\u00a0 str(day) + “, ” + str(year)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 return date<\/p>\n

Field Calculation:
\n\u00a0\u00a0\u00a0 function( !MonthText! , !DayCollected! , !YearCollected! )
\nCollector<\/strong><\/span><\/p>\n

We sorted the Collector field and selected the null values. We then used the field calculator to set the null values to \u201cUnknown\u201d.<\/p>\n

Now the data are ready for use in our web map. Right click the table in ArcMap and export the table to a text file (*.txt).
\nNext week<\/strong><\/span><\/p>\n

Next week we will show you how to configure a custom pop-up format that we used to make our new speckled dace web application<\/a><\/strong>.<\/p>\n

Download the Field Calculator Scripts<\/strong><\/span><\/p>\n

We posted the field calculation scripts<\/a><\/strong> on the ArcGIS Hydro Resource Center for you to download, use, and modify.<\/p>\n

County_caps.cal
\nCounty_Cleanup.cal
\nDate.cal
\nLocality.cal
\nSpecimen_html.cal
\nSplit_CatalogNumber.cal
\nState_caps.cal
\nSpecial Thanks to: <\/strong><\/span><\/p>\n

The Fishnet data portal<\/a><\/strong> data portal and the following institutions for providing the data used in this application:<\/p>\n