Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Creating Maps with 5-Digit Zip Code Data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Creating Maps with 5-Digit Zip Code Data
 Login/Join
 
Member
posted
Hello,

I'm about as new as they come to the WebFOCUS universe. I've successfully created state and 3-digit zip code maps in AppStudio after moving several of the prepackaged JSON files to the specified path(/opt/webfocus/ibi/WebFOCUS80/config/web_resource/map), updating the CustomUIMaps.xml, and restarting Tomcat. I can tread water doing that.

However, I'm now tasked with creating maps based on a 5 digit zip. With no such prepackaged JSON onboard, IBI Support pointed me in the direction of (https://www.census.gov/cgi-bin/geo/shapefiles2014/main) where I downloaded the ZIP Code Tabultation Areas data. This consists of the following seven file.

tl_2014_us_zcta510.dbf (2,267KB)
tl_2014_us_zcta510.prj (1 KB)
tl_2014_us_zcta510.shp (817,495 KB)
tl_2014_us_zcta510.shp.ea.iso (XML Document)(17 KB)
tl_2014_us_zcta510.shp.iso (XML Document)(34 KB)
tl_2014_us_zcta510.shp (XML Document)(18 KB)
tl_2014_us_zcta510.shx (260 KB)

Obviously, there is no JSON format to work with. I've read a bit about converting SHP files to GEOJSON with (http://www.gdal.org/ogr2ogr.html) but it's mostly greek at the moment as the programming gene seems to have escaped me at birth.

Any direction as how best to proceed would be much appreciated.

Thanks!
Joe

WebFOCUS 8.0.0.9 on AS400

This message has been edited. Last edited by: Joe Bryant,


WebFOCUS 8.0.0.9 on AIX
 
Posts: 2 | Registered: April 30, 2013Report This Post
Member
posted Hide Post
At the Atlanta User's Group meeting yesterday, representatives from the IBI Southern Area, Business Solutions Group were able to provide me with GeoJSON files for the five digit zip code range of each state. The needed files were copied to our development server, Tomcat cycled, and maps successfully produced based on these files.

Below is an excerpt of an email from that ibi group in which further information is provided:

quote:
On my test system I placed the .geojson files in this folder:
C:\ibi\WebFOCUS80\webapps\webfocus\tdg\jschart\distribution\map

Then I edited the UIMaps.xml file and added Alabama and Georgia, so mine ended up looking like this:

<Json>
<Map layer="regions" name="USA" file="US.json"/>
<Map name="WF Retail Regions" file="sample_wfretail_regions.geojson"/>
<Map name="Georgia Zip5" file="GA_5.geojson"/>
<Map name="Alabama Zip5" file="AL_5.geojson"/>
<Map layer="regions" name="US Zip3" file="uszip3.json"/>
<Map layer="countries" name="World" file="world.json"/>

As far as I know, this requires a restart of Tomcat not just the Reporting Server.

Also for the conversion of your “Shape” files, here is the information from one of the other SE team members:
1. Get Boundary information in KMZ or SHP file formats, some of this can be found on the web for generic areas (example Cities).
2. Convert those to GEOJSON. If you use an online converter, make sure that it moves the zip code values in. He used ogr2ogr (http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet), a command line tool for this. This gave a large file with the boundaries and many properties, which he stripped down to just the zip code property and boundary.
3. Run the mapshaper.org web site, just drag your geojson file in, to simplify your map (reduce the detail in the boundaries to get the file smaller). The important point here is to reduce the complexity without getting Nulls, as WebFOCUS is not very happy when it encounters Nulls. (Simply reduce to the point where you get Nulls, then either back it out a little higher so you don’t get nulls, or strip them out.)

Hope this will work for what you are looking for.



This was indeed exactly what I was looking for. Thx! Joe

This message has been edited. Last edited by: Joe Bryant,


WebFOCUS 8.0.0.9 on AIX
 
Posts: 2 | Registered: April 30, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Creating Maps with 5-Digit Zip Code Data

Copyright © 1996-2020 Information Builders