Showing posts with label Honolulu. Show all posts
Showing posts with label Honolulu. Show all posts

Thursday, June 6, 2013

National Day of Civic Hacking Honolulu: The Mapping Guy

Looking for the links to State of Hawaii and City and County of Honolulu map services? They're about half way down through this blog. I hope you'll read the whole blog, but if you need the links quickly, here they are:


                                                                                                                            

On June 1, 2013, Honolulu held an event as part of the National Civic Day of Hacking. Thanks to Burt Lum and the Code for America Honolulu Brigade for organizing and sponsoring Honolulu's event.  About half of the 50 or so people at the event were software developers, the other half were government representatives and interested citizens.

Burt introduced me as "the mapping guy" and it's true, my passion is maps and now online maps and mapping applications.

I've given talks at Hon*Celerator, Unconferenz 2013 and the PCATT IT Summit where I talk about the importance of maps and how lists of locations are good, but maps of locations are better. And dynamic maps based on map services and map applications that provide search and analysis tools are the best. Many of my past blogs have been on this same theme:


So I wanted to talk about three things, a bit different, but related, on this day of civic hacking. "No FTP / Download" is for the software developers. "Gov Apps = Citizen Apps" is for government and citizens. "Vote" is for everyone.

NO FTP / DOWNLOAD

Government is opening up more and more data and sharing it with the public. Why do I say "NO FTP / DOWNLOAD"? It was interesting how many other presentations during this national day of civic hacking involved maps. But if you stop and think about it, this makes perfect sense. Much of the data that citizens are interested in is data on places close to where they live, work, go to school and play - yes, maps!

The mapping community has been sharing open mapping data for a number of years now and one of our lessons learned is that data gets stale, it gets old, it gets outdated. At first, all we could do was go back to the ftp site regularly and check if there was an update. If there was, we'd download and process it.

But as internet connection bandwidth increased it became possible to make current mapping data available as map services. No more FTP, no more downloads, no more stale data! There are still times when I need to download mapping data, but more and more I'm able to work with the map services directly. The State of Hawaii and all four counties (Hawaii, Maui, Honolulu and Kauai) have started publishing mapping data as RESTful map services.

And it's not just mapping data. Both the City and County of Honolulu and the State of Hawaii use Socrata to host their open data portals. Data on Socrata can be downloaded, but is also available via their SODA RESTful services.

Software developers need to know how to use these RESTful services so they can decide when it's best to download data and when it's best to connect to a service. Here are a couple of examples where connecting to a map service is better than downloading.

Oahu Tsunami Refuge Centers

When a tsunami watch or warning is given, residents and visitors in tsunami evacuation areas need to leave the area. Residents often go to a family or friend's home that is outside the evacuation area. Visitors can evacuate to the upper floors of their hotels. Another option is to go to a tsunami refuge center. These centers are not shelters, they don't provide food or services, but they do provide a safe place, usually with restroom facilities, to wait until the danger has passed.

An earthquake in Canada on October 27, 2012 caused a tsunami and Hawaii received a tsunami warning. All I could find online was a list of the tsunami refuge centers, and since lists are good but maps are better, I created a mapping application that showed the evacuation zone and the refuge centers. I wrote about this on my blog and also in an article in Civil Beat that called for the government to make better use of map services to inform the public.

The City and County of Honolulu now publishes a tsunami mapping application similar to what I created during the tsunami event. Their application uses a web map with two map services also published by the City and County of Honolulu - one for the tsunami evacuation zones and one for the refuge center locations. Both these map services are open so that software application developers can use the data in their own apps.

So if you're developing an application using tsunami refuge center data, would it be better to download the data, or better to connect to the service provided and updated by the City and County of Honolulu? If you connect to the service, then as soon as the City makes a change to the data, your application will immediately see it. If you download the data then...

Hawaii Flu Vaccination Sites

The State of Hawaii Department of Health has taken what used to be a 14 page PDF list of flu vaccination locations and turned it into a mapping application that shows the locations, whether a prescription is required, whether an appointment is required, and lots of other useful information. Similar to the tsunami application, this application uses a web map with a map service of flu shot locations that is published and updated by the Hawaii Department of Health. This map service is also open so that application developers can use the data in their own apps.

The data behind the map service is updated regularly and of particular interest is a data field or column called "ShotsAvail". This column has two possible values - "Yes" or "No". If your app connects to the service, then you can use this information to correctly show which locations have either flu shots or flu mist available (Yes) and which have neither available (No). In the mapping application, only those sites where "ShotsAvail" = 'Yes' are shown. But the map service contains all the locations so you as an app developer need to pay attention to this value.

State of Hawaii and City and County of Honolulu Open Mapping Data

Hawaii, Maui and Kauai are just getting started with their open mapping portals, but the State of Hawaii and the City and County of Honolulu have published quite a few map services along with web maps and mapping applications. I showed these at the civic hacking event but the URL was too long for people to copy down, so here are the links:

   State of Hawaii Open Map Services (developers connect to these map services)

   City and County of Honolulu Open Map Services (developers connect to these map services)

These are the same links that are at the top of this blog post.

GOV APPS = CITIZEN APPS

In my Ignite talk at Unconferenz 2013, I talked about the importance of maps and open data, but also about the importance of open tools for analysis. Access to maps and data is great for citizens to have, but sometimes there are also analysis tools used by government to help understand data and to create future alternatives based on actual data. In my talk I urged that government provide these same tools to citizens.  

In my talk at civic hacking I explained in more detail a project I was involved in where this was done and how citizens used analysis tools, the same tools used by government, to provide informed public testimony that did influence government decisions.

My example was redistricting. I was the mapping guy supporting the State of Hawaii Reapportionment Commission. Reapportionment and redistricting is done every ten years following the decennial census to adjust political boundaries to balance population changes. I won't get into the details on the process, you can read more here if you're interested.

The Commission was using an online mapping application that had maps, census data and analysis tools to help them re-balance the political boundaries. What is interesting is that the Commission decided to make this same online mapping application available to the public. Anyone could get a login by providing their email address and then create their own redistricting plan using the same tools as the Commission.

The public responded! By the end of the process, 586 accounts had been opened and 845 redistricting plans were created. Members of the public came to public hearings and not only submitted oral testimony, they also submitted their maps and they submitted their plans. It was a great success. And because I was the map guy working with the Commission, I can say with confidence that these publicly created maps did influence Commission decisions and that the final maps adopted did contain changes that came from public input.

And because the Commission's mapping application was using map services, those same map services, open to the public, could be used to create other applications. I created a web map and mapping application that was published to desktop and mobile devices. Smartphone users could install an app and then open up the new political maps on their iOS, Android and Windows devices.

So "Gov Apps = Citizen Apps" is my way of saying that if the government is using apps (tools) as part of their decision making, that whenever possible, those same tools should be made available to the public.

VOTE

Hawaii ranks low nationally in percent of voter registration and voter turnout on election day. There are many reasons posited for this, but my hope is that better access to government data, maps and tools will help spur understanding of and interest in government.

We were asked to come to this meeting with ideas for civic hacking projects. I don't know what form it might take, but I'd be very interested to work with a team on civic applications to try and increase Hawaii's rate of voter participation. Maybe an app for voter education, maybe an app to encourage voter registration, maybe an app to make more information on candidates and issues easily available.

Feel free to use the comment section on this blog to post your ideas on how we might do this.

And if you are a US citizen and a Hawaii resident 18 years or older, and you haven't registered to vote, do it now!

A hui ho!

Monday, May 27, 2013

Big Island User Group Links - May 28, 2013


UPCOMING EVENT LINKS

May 30, 2013   Smartphone GIS: Capturing Data with Collector for ArcGIS   (webcast)
                          (link to archive of previous webcasts)
Jun 26, 2013   HIGICC Annual Meeting   (Honolulu, Hawaii)
Jul 6-9, 2013   Survey Summit   (San Diego, California)
Jul 8-12, 2013   Esri International User Conference   (San Diego, California)
late July or August   Hawaii time zone   (instructor-led online classes)
   Class: Migrating to ArcGIS 10.1 for Server
   Class: ArcGIS for Server: Sharing GIS Content on the Web (10.1)
   Class: ArcGIS for Server: Site Configuration and Administration (10.1)
             
GIS AND OPEN DATA LINKS

State of Hawaii Office of Information Management & Technology OIMT homepage
State CIO Sonny Bhagowalia's Keynote at Hawaii Pacific GIS Conference 2012

State of Hawaii Open Data Portal
State of Hawaii Open Data for Mapping   (ArcGIS Online)
City and County of Honolulu Open Data for Mapping   (ArcGIS Online)
Maui County Open Data for Mapping   (ArcGIS Online)

Developer API Mapping Applications
Parcels and Zoning Fast Maps   (City and County of Honolulu)
EnerGIS Renewable Energy   (State of Hawaii)
Flood Hazard Mapping   (State of Hawaii)
Crime Mapping   (City and County of Honolulu)

Web Map Mapping Applications
Sewer Projects Construction Map   (City and County of Honolulu)
Tsunami Refuge Centers   (City and County of Honolulu)
Refuse and Recycling   (City and County of Honolulu)
Electioneering App   (State of Hawaii)
Exceptional Trees   (City and County of Honolulu)
Exceptional Trees with Tree Finder   (City and County of Honolulu)
Veronese Mythological Paintings Story Map   (spreadsheet from Ria Baldevia)
San Diego Story Map   (uses three web maps)
Moore Tornado Story Map   (uses two web maps)
Gallery of Story Maps

ARCGIS ONLINE RESOURCE LINKS

ArcGIS Online Tutorial with Exercises
ArcGIS Ecosystem Seminar   (one hour webinar)
ArcGIS Online for Administrators   (two module web course)
ArcGIS for Desktop Staging Tips for ArcGIS Online

A COUPLE MORE THINGS...
ArcGIS for Desktop Editing   (Technical Workshop Video)
ArcGIS Desktop for Home Use
ArcGIS Online - All Blogs 
ArcGIS Online - Bern's Blog 



LGIM - Local Government Information Model Maps and Apps 
LGIM Maps and Apps for Water Utilities 
LGIM Maps and Apps for Public Safety 
LGIM Maps and Apps for Land Records 

Friday, May 24, 2013

Maps That Change Quickly: Honolulu Lei Drop-off Sites

Photo courtesy U.S. Navy
http://www.flickr.com/photos/usnavy/7301706022/

May 24, 2013  Honolulu, Hawaii

Driving in to work today, I heard on Hawaii Public Radio that the City and County of Honolulu was seeking 50,000 donated lei to be used as part of Memorial Day services. This is something the City does every year to decorate the graves of fallen service members at the National Memorial Cemetery of the Pacific at Punchbowl and the Hawaii State Veterans Cemetery in Kaneohe.

The Mayor's Memorial Day Ceremony at Punchbowl will be held on Monday, May 27th at 8:30 am. Here's a link with more information on that event:

     Mayor's Memorial Day Ceremony 2013

Lists are good, maps are better!

At the end of the story on the radio, the announcer listed a number of locations on Oahu where donated lei could be dropped off. If you've read some of my other blog posts you've have heard me say it before - "lists are good, maps are better". A list provides basic information which is better to have than no information at all, but when it is a list of locations, a map is so much better. It is much easier for people to see a map and then find a location near them.

So I decided to turn the list into a map. But I didn't have much time. The locations were only open one day, this day, May 24th, in the morning. Some closed at noon, some at 1 pm and the rest closed at 2 pm. So I had to work fast. Here's what I did.

List of locations to map features

There were three types of drop off locations - fire stations, parks and park offices. There were a number of ways I could use to turn the list of locations into features on a map. I could work from a spreadsheet, but I knew that most of the locations were already in GIS format and available as different map services from the City and County of Honolulu so I decided to work in ArcGIS for Desktop. I created a template shapefile, brought in the different map services, selected the features I needed and copied them into my shapefile, and then edited the attributes - basically the name of the location and the hours it was open.  Here are links to the two map services I used:



Map features to web map

The next step was to add my shapefile map features to a basemap to create a web map. I used ArcGIS Online to create the web map including setting symbology (a flag at each location - this is for Memorial Day after all) and configuring the popup window to show the name and hours information. I saved my web map and gave it this description:
The description is important because in the next step I will use a template to create a mapping application. The template will present this description information on the left side of the map.

Web map to mapping application

In ArcGIS Online there are a variety of application templates available. I choose to use one called the "Basic Viewer" template. I turned off many of the tools in order to keep the application simple. I set the logo in the lower right hand corner to point to a City and County of Honolulu logo and saved my application configuration.  here's what it looked like:


You can see above how the text from the description was incorporated on the left side of the mapping application. The flags marked each of the drop-off locations.  


Clicking on a flag showed the name and hours for that location as shown above.

Time to share

All the above data editing, web map creation and map application configuration took about an hour from start to finish. During that hour, only I could see my web map and mapping application, but now that it was ready, I set the sharing property for both to "Everyone" which means anyone with internet access can see my mapping application. Time to send out a tweet...


Time to change the map!

The fire stations stopped accepting lei donations at noon. The parks stopped at 1 pm, and offices at Fasi Municpal Building and Kapolei Hale stopped at 2 pm. This information was in the popup window for each location, but I wanted to make the map more dynamic. If someone opened my mapping application after 12 noon, I wanted them to quickly be able to see only the locations which were still open - the parks and offices.  And if they opened my mapping application after 1 pm they'd only see the two offices.

So how could I quickly change my mapping application? It turns out to be pretty simple. Because my mapping application uses my web map, all I had to do was change and save my web map and the mapping application would update automatically. This loose coupling of web maps and mapping applications had worked well for me before with my electioneering app in the General Election of  2012 and it worked well again.

At noon I went in to my web map and changed the symbology for the fire stations from a flag to a light orange dot. At 1 pm I did the same for the parks, and at 2 pm I did the same for the two offices.  It worked great, it was very easy to do, and it made the maps easier to read.  

At 2 pm, when all the locations had closed, I called the City and County of Honolulu Department of Parks and Recreation to confirm that all the locations had closed.  They informed me that one site was still open, that donated lei could be dropped off through the weekend at the National Memorial Cemetery of the Pacific at Punchbowl.  Thus, for the final change to my map, I changed the basemap from streets to imagery and only showed one location, Punchbowl. I also changed the web map description to reflect the new information - which was automatically used by the template.  Here's the final mapping application:


I suspect there are many times when this ability to quickly change the features on a map will prove useful.  I'm on the lookout for more opportunities.  If you have an idea, let me know!

Wednesday, May 15, 2013

There's A Map For That: Online Mapping Resources for Hawaii

PCATT IT Summit
Presentation Notes
May 16, 2013
1:15 to 2:00 pm
Room 514

I love maps! And I love teaching teachers about maps and mapping software. So the PCATT IT Summit is a great chance for me to reach Hawaii high school Career and Technical Education (CTE) teachers and show them the great online mapping resources available here in Hawaii including data from the State of Hawaii and from our four Hawaii counties - Honolulu, Maui, Hawaii and Kauai.


Instead of handing out a piece of paper, I decided to blog my notes and relevant links so they're easy to find and share. So here we go...

These will only be some brief notes along with links to online resources. If you're interested, my full presentation is posted on slideshare. It's also embedded here:



GIS = ( ( Maps + Data ) * Analysis ) ^ ( Web + Mobile )

This handy formula summarizes the power of GIS, or geographic information systems. We start by looking at maps, but we more than just a map. We see things (features) on the map. And behind every feature on the map there is data describing that feature. On a paper map we can't see all that data, but when we bring that map on to a computer (using GIS), we can start asking questions and seeing patterns. We can start doing analysis. Analysis is the "force multiplier" of GIS. And in the last few years, all that power of GIS has been multiplied exponentially via the web and, even more recently, via mobile devices.

There was an article in the December 2011 issue of Honolulu Business Magazine that describes this in more detail and gives examples of how business and government use GIS. Here's the link:


There are many mapping applications now online, here are links to a few local ones you may find interesting:

Map Services to Web Maps

Behind the scenes, the mapping applications above are all using map services to create the maps and reports you see online. You can use these same map services to create your own online maps called web maps.  Here are some links to map services, web maps and web map applications:



Software, Training and more...

Fortunately for Hawaii teachers, the Hawaii Department of Education has a site license for the GIS software used for both desktop (ArcGIS for Desktop) and online (ArcGIS Online) mapping software that teachers can use for free!  The licenses are administered for DOE by the MEDB Women in Technology (WIT) Program.  Here are some useful links:


Thursday, May 2, 2013

Zero to App in 36 Hours: Oahu's Exceptional Trees

I've been a judge at a couple of hackathons (software development competitions) here in Honolulu. The teams that win often use several application development tools that they know well and can mix and match to come with a good solution in a short amount of time. I recently had a chance to use several of the mapping tools that I know well to create an app in less than 36 hours.  Here's the story...

Burt Lum (@Bytemarks) posted a dataset on the City and County of Honolulu's ("the City's") open data portal (http://data.honolulu.gov) that listed 166 exceptional trees on the island of Oahu. Click here for more information on Oahu's exceptional trees program.

April 30, 2013 10:51 am: Burt sent a tweet about the new dataset and noted there were no GPS coordinates, only TMK values. TMK (Tax Map Key) numbers are used as parcel identifiers in Hawaii, so the dataset showed which parcels the trees were on, but not the specfic location of each tree.

Ryan Ozawa (@hawaii) brought me (@rajhawaii) into the conversation suggesting I might have an app for TMKs. I didn't, but it got me thinking that I could build one pretty easily.

I started by exporting the dataset as a spreadsheet and then bringing it into ArcGIS for Desktop. I've been using this GIS (geographic information system) software for many years and it is great for exploring and editing map data, combining different map datasets, and doing spatial analysis. I knew that the City's mapping open data portal (http://cchnl.maps.arcgis.com) had TMK parcels as a map service. All I needed to do was to re-format the TMKs in the spreadsheet to match the format of the map service and then I would have a map of the parcels with exceptional trees.

Once I had the map dataset of parcels with exceptional trees, I turned to ArcGIS Online to move the data from my desktop to the City's mapping open data portal. I uploaded the dataset and published it out as a feature service. This feature service is now available for anyone to use for their own maps or mapping applications. Click here to learn more about this feature service.

Now that I had the feature service published, I needed to combine it with a basemap and define the symbology and configure the popup window to show attribute data. I again used ArcGIS Online, this time to create a web map.  I choose an imagery basemap, and since this is tree data, I symbolized the parcels with a green outline and an interior green color at 90% transparency. I configured the popup window to show the common name and species name of the trees as well as some locational information. This web map is now available for anyone to use for their own mapping applications. Click here to learn more about this web map.

Now that I had a web map, I could use it conjunction with one or more map application templates to create a web map application.  I started with a simple template that provides the user with a few simple tools to search for places, to change the basemap, and to share a map via email, Facebook or Twitter.

May 1, 2013 10:57 pm: Almost exactly 36 hours after Burt's initial tweet, I was able to tweet the link to my completed web map application. Click here to see it.

I have since used the same web map to create a second application that provides the ability to search by tree name. Click here to see it.

And finally, I can embed my web map into any web page including my blog, so here it is... zoom in, zoom out, pan across to see other parts of the island. And be sure to click on a green parcel to get info on the trees!



A hui ho!

Thursday, December 6, 2012

A Map for Every Story: Honolulu Sewer Projects

Have you ever noticed the lists of various road work projects going on that are published in the papers and government websites?  Have you ever wished that instead of a list they would show you a map?

List of Sewer Projects
List of Sewer Projects
Well, the City and County of Honolulu has heard your wish and they've started working on it.  The Department of Planning and Permitting (DPP) and the Department of Environmental Services (ENV) are publishing a web map that shows where sewer projects are taking place.

Let's start with the list.  Here's the way that information on sewer projects has been presented to the public for years.

Nice to have a list, but wouldn't a map be even better?

And here it is, a web map of sewer projects that is now being published by the City and County of Honolulu.

Web Map of Sewer Projects
Web Map of Sewer Projects
The areas where sewer work is being done are highlighted in red.  if you click on one of the red lines, you will see information on that sewer project.

In this example, I clicked on a project near Ala Moana and a popup window opens to show information about that specific project.

It's simple, it makes it easy to see where sewer projects are happening, it's available for the public, and it's free.  Here's the link if you want to try it out:

Link to web map "Sewer Projects Construction Map"

I commend the City and County of Honolulu DPP and ENV for setting an example of how web maps can be used to easily convey location-based information to the public.  Now for that list of water projects, road work projects, parade routes...

Thursday, November 1, 2012

A Map for Every Story: Hawaii 2012 General Election

Political sign waving in Hawaii has been a tradition for decades. However, it is illegal around early voting sites through Nov 3 and around all polling places on Election Day Nov 6. Hawaii Revised Statutes §11-132 provides the details, basically no campaigning is allowed within 200 feet of a polling place including parking and access. Here's the link if you want to read the details:  
Link to Electioneering and Campaigning Factsheet
Old Electioneering Map for DP 21-02


Until now, if you wanted to see a map, you had to know the precinct (or DP) number.  Then you could go to the State Office of Elections website and download the map.  The map was also posted at the polling place.  Here's an example, the old electioneering map for DP 21-02.




But these days, with satellite images, with smartphones that know where they are, with online web maps, there must be a better map we can use for this story.  Esri worked with the State Office of Elections and the State Office of Planning to create new electioneering maps.  Here's the new electioneering map for DP 21-02.


These are not just static maps.  These maps are published online and can be viewed by anyone for anywhere in the state.  Better yet, smartphone users can use their phone to see the electioneering map for their current location.  



There is a gallery of regional maps for desktop and tablet users:

Here's the link:
Link to Hawaii Electioneering Map Gallery for Desktop and Tablets

Smartphone users, here are the links to mobile maps for each county:

Honolulu Smartphone Electioneering Maps
Hawaii County Smartphone Electioneering Maps
Maui County Smartphone Maps
Kauai County Smartphone Electioneering Maps

After you open the map on your phone, you can click the locate button (circled in red in this example) to move the map to your location.


ELECTION DAY UPDATE - NOV 6, 2012

After the polls closed on Election night, the electioneering gallery had been viewed 814 times. There were 1,173 views of the regional maps - 836 via desktop/tablet and 237 via smartphones.

Tuesday, October 30, 2012

A Map for Every Story: Oct. 27 2012 Tsunami in Hawaii

On October 27, 2012, a magnitude 7.7 earthquake off the west coast of Canada triggered a tsunami warning in Hawaii.  Residents and visitors in tsunami evacuation areas were warned to evacuate to higher ground.  For visitors in hotels, this usually meant moving to a higher floor.  For many residents it meant going to a family or friend's home outside the evacuation area.

HPD Facebook page
For those on Oahu needing a safe place to go, the City and County of Honolulu established 26 Tsunami Refuge Centers.  This information was shared with the public in list form.  The list looked like this on the HPD Facebook page:

Certainly a map can help with this story.  A map showing each of the refuge centers.  A map that could be opened on a desktop, tablet or smartphone.  A map that could show the refuge centers around a user's location. A map app that could be developed quickly.

It took me about one hour.  I used ArcGIS Online and created a web map combining map services from the City and County of Honolulu along with data points for the refuge centers.  I made several copies of this web map, each zoomed in on a different area on Oahu.  I then created an ArcGIS Online group and gallery for the web maps.

The gallery is still online.
You can view it at this link:

Oct 27, 2012 Oahu Tsunami Refuge Center Maps

I used Twitter to share links to the gallery and to each of the regional maps using the #hitsunami hashtag that was used during the event.  Interestingly, though maybe not surprisingly, the regional map links were re-tweeted more than the gallery link.

The first wave arrived at 10:28 pm (22:28) local time.  Fortunately for Hawaii, the tsunami was only 2.5 feet high and there were no immediate reports of damage.  While the evacuation was a necessary precaution given the uncertainty in predicting tsunami wave heights, in this case residents and visitors were soon able to resume their normal activities.

Tuesday, October 9, 2012

A Map for Every Story: Honolulu Council District VI Special Election

Will I be able to vote in the Honolulu Council District VI Special Election?

If you're blogging or writing an article on the Honolulu Council District VI Special Election 2012, here's a map for that story:


View Larger Map

You can embed this same map in your story using the HTML code in this file:
https://docs.google.com/open?id=0B79hRbgog1SbVmJWaHh0SDNrTUk