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.
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.
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 AS400This message has been edited. Last edited by: Joe Bryant,
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:
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! JoeThis message has been edited. Last edited by: Joe Bryant,