Display table of data link records in map tip
I have layer of facilities with a data link to records of products and quantities by site. Some facilities only have one product and some have several products. What I would like to do is make a table in the map tip that shows a list of products and quantities for each site.
Has anyone accomplished anything like this, or does anyone have any ideas on how to go about doing this?
Thanks,
Denise
0
-
Denise,
If you have not done so already, add the LA_County demo site from the Sample_Sites folder to your Sites directory. Paste this html code into the feature details pane for the ZIP CODES layer. It is located in the Administrative Areas > Zip Codes.
<table style="width:99%;">
<tbody>
<td><p style="text-align: justify;">The Zip Codes Layer description...</p></td>
</tbody>
</table>
<table style="width:99%;">
<tbody>
<tr>
<td style="border:0.5px solid rgb(215,215,215)"><span title="This is the information for cultural amenities."><b> Cultural Amenities:</b></span></td>
<td style="border:0.5px solid rgb(215,215,215)"> {Culture}<br /></td>
</tr>
<tr>
<td style="border:0.5px solid rgb(215,215,215)"><span title="This is the number of establishments in this zipcode."><b> Establishments:</b></span></td>
<td style="border:0.5px solid rgb(215,215,215)"> {Historical_Employment_Data.Total Businesses}<br /></td>
</tr>
<tr>
<td style="border:0.5px solid rgb(215,215,215)"><span title="This is the number of employees working in zipcode" {ZIP}><b> Employees:</b></span></td>
<td style="border:0.5px solid rgb(215,215,215)"> {Historical_Employment_Data.Total Employees}<br /></td>
</tr>
<tr>
<td style="border:0.5px solid rgb(215,215,215)"><span title="This is the year for the data."><b> Year:</b></span></td>
<td style="border:0.5px solid rgb(215,215,215)"> {Historical_Employment_Data.Year}<br /></td>
</tr>
</tbody>
</table>
You will see that zip codes has a data link with this SQL query:
SELECT Year, ESTABLISHMENTS as [Total Businesses], EMPLOYEES as [Total Employees], PAYROLL_1STQ as [First Quarter Payroll], PAYROLL_ANN as [Annual Payroll] FROM ZIPCODEJOBDATA WHERE ZIPCODE = ?
This should help you visualize on how to link the two together.
Feature Details Popup Image
Cheers...Rick0 -
Also note the the <span title> tag contains the hover description for the attribute.
Rick0 -
Hello Rick,
Thank you for your response! I am looking to create a table from data that looks something like the contents of the cell next to "Cultural Amenities", only imagine that the name and quantity of each amenity is coming from a separate record in a one-to-many data link.
Luckily we have an awesome programmer, and I was able to get him to create me a whole new SQL view with one record for each facility, and a field that is populated by a string that is actually an HTML-formatted table of all the related products and quantities for each site. So I don't need a datalink anymore. I just add one replacement token for the formatted table field, and a beautiful table shows up in the map tip! So I'm kind of cheating, but I'd still be interested in alternative solutions!
I did take a look at the "Culture" Arcade Expression on the Zip Code layer, and it's really interesting! It's good to know that it's there, and I can see it coming in handy one day.
Thank you,
Denise0 -
Denise,
Could you share a screen capture of your popup table?
<< I did take a look at the "Culture" Arcade Expression on the Zip Code layer, and it's really interesting! It's good to know that it's there, and I can see it coming in handy one day. >>
Please know that the next release of Geocortex Essentials 4.13 (end of March) will include Arcade support for popups. I'm really exited about this.
Cheers...Rick0 -
Denise.
<< I did take a look at the "Culture" Arcade Expression on the Zip Code layer, and it's really interesting! >>
Know that you will be able to use Arcade expressions in a popup in the next up coming release of Geocortex Essentials. I'm really looking forward to that!
Rick0
Please sign in to leave a comment.
Comments
5 comments