CitySmart Blog

Thursday, April 19, 2012
Todd Snoddy, Senior Software Developer
Late last year, Philadelphia’s mayor announced the launch of a special website called ‘Change By Us Philly’ that provides an interactive, social media platform to enable residents to connect with city officials, community-based organizations and each other to share ideas and create projects to benefit the City of Philadelphia. The website is accessed at and is operational.

In a press release, Mayor Nutter called the website an innovative, social media tool that will help create initiatives to make Philadelphia a “smarter, safer, greener, cleaner and better City.” 
Chicagoans also were encouraged to use an interactive website — — to submit their ideas on how to erase a $635.7 million budget shortfall. Within days of the launch, there were 305 ideas posted on the website. The site also included 2,680 votes and 500 comments. 

While Philadelphia and Chicago are two large cities, municipalities of all sizes are learning to work the web in different ways to engage residents and encourage them to participate in relevant “discussions” about issues impacting their communities.

According to an article in The Atlantic Cities online magazine, cities also are starting to use websites to conduct virtual town hall meetings and for official city blogs or elected city leaders. The article referenced a recent report from researchers at the University of Illinois at Chicago that compares the websites of the 75 biggest cities in 2009 and 2011. Over that time, Twitter use increased 62 percent, Facebook use by 74 percent and YouTube linking by 59 percent.

The report states that local websites help make basic information about cities available, including contact information, government policies and processes, government organization, information about council meetings, and important policy documents, such as budgets. This improves transparency and offers citizens information that could help them to intervene on issues if they so choose.

With that as a backdrop, cities of all sizes need to ensure they are using their own websites in ways that help deliver value to residents and drive efficiency for local government agencies.

Friday, March 23, 2012
Dave Mims, President

Save time. Save money. Cut cost. When it comes to business operations, those three objectives are always at the top of the list. City governments are looking for ways to communicate and disseminate information quicker and more cost-effective than before. So where do you start? You can stop using all that paper for starters.

Because paper is relatively cheap to purchase, it is not automatically seen as an expense to cut. It’s time to reconsider that thought. City governments are finding ways to use less paper, while saving their organizations time and money. The City Council of Vancouver, Wash., recently made the switch from paper to iPad communication at the beginning of this year. According to a March 5 article in, the Vancouver City Council saw a 40 percent reduction in paper usage in just two months. This would amount to about 50,000 pages of paper over the course of a year.
Instead of using hard copies, the council uses iPads to disseminate important information during meetings and internal sessions, as well as the applicant review process for advisory board/commission vacancies, according to CNET. Since the council began using iPads, there has been a noticeable increase in productivity during meetings due to the larger screens when compared to smartphones and ease of use when reading documents and viewing Web sites.

Surprisingly, iPads also turn out to be cheaper than the council’s previously used BlackBerry smartphones. At $43 a month for the unlimited data, the iPad is $28 cheaper than the BlackBerry. The City of Vancouver will save nearly $340 a year per device, creating opportunity to invest that money elsewhere to help citizens.  

Looking for more cost effective ways to communicate easier and quicker? Take a cue from the City of Vancouver. Their investment in new technology has put them on the cutting edge while cutting their budget at the same time.
Friday, March 23, 2012
Vladimir Maysuradze, Senior Software Developer / DBA

Microsoft announced that the latest version of SQL Server has been released to manufacturing and will be generally available April 1st (interesting choice for date to release a major product, don’t you think?). This release is packed with plenty of new toys for everyone. DBAs will love the new availability feature called AlwaysOn and performance enhancing columnstore indexes. Developers should be looking forward to the SQL Server Data Tools as well as multiple language enhancements, like window functions. BAs will be interested to learn about multiple enhancements to the SSAS including the addition of the data visualization tool Power View. As always, organizations should exercise caution when adopting new technologies. Enjoy it, with care!

Saturday, March 17, 2012
Dave Mims, President

There are so many in need in this world, and we are all very fortunate and blessed. 

Sophicity signed up, along with other corporate sponsors, to help Sheltering Grace Ministry through High Tech Ministries Serve@Work first service project for FY2012. At this project we came out with jeans, T's, and tools to complete a Home Makeover (removing trees, landscaping, replacing a roof, replacing siding, replacing cabinets, paint, building storage unites, etc.)

Ralph Bell, the Executive Director of Sheltering Grace, shared "Each time I visit the Richard Street property I remember you guys and the rest of the team and how much you gave of yourselves to benefit others, the women in our program. I am still amazed at the transformation of this property as are all the neighbors. Your work is a testament to the love of our Lord and the dedication of His people to serve others, to be His hands and feet in this lost world."

From Scripture, Jesus says “Assuredly, I say to you, inasmuch as you did it to one of the least of these My brethren, you did it to Me”. In the back yard, Quan counted how many stones there were with names of children carved in them. Each name represented a child born as a result of this ministry. There were 36 stones. 36 children born because of that small house. That means there were 36 homeless pregnant women in need, in trouble, nowhere to go, and this ministry provided a place of refuge, a place of safety, a place for that child to make it into this world, a chance for life.

Helping one makes a difference. Helping an organization whose mission is to help those in need, makes a difference.

God bless.

Thursday, March 15, 2012
Dave Mims, President
Americans are using mobile devices to accomplish everyday tasks from making phone calls and taking pictures to visiting websites and paying bills. According to the *Pew Internet & American Life Project, 88 percent of American adults have a cell phone. As of February 2012, most of those cell phone owners are actually using smartphones. About six in 10 adults (63 percent) go online wirelessly and according to the 2011 Mobile Year in Review on, more smartphones were purchased in 2011 than PCs.

So, how do you communicate with your citizens? Business and government agencies alike rely on mobile technology. A recent report from Government Technology states nearly 60 percent of state and local IT professionals surveyed expect their respective agencies to spend more money on mobile devices and services in 2012.

DuPage County, Ill. has come up with a great mobile solution. The DuPage Green Grid is one example of how local government is using mobile technology to communicate with its citizens. The DuPage Green Grid identifies alternative fuel stations, car share location and buildings certified by the Leadership in Energy and Environmental Design (LEED) program throughout the area. Designed as an app, it is based on GIS technology and is available to residents for free.

Local governments nationwide have actually caught onto the trend. Last year, Sacramento County launched its first app, which spotlights the health scores of nearby eateries. Various counties also have produced snowplow apps so residents can track what roads have been cleared before venturing out into snowy conditions. 

According to, one billion apps were downloaded each month worldwide in 2011. Eight trillion texts were sent last year and there was a 166 percent increase in Facebook mobile users in the first half of the year alone. Your citizens are viewing the world from a much smaller mobile lens. Since they are, make sure they see you!

* Brenner, Joanna. Pew Internet: Mobile. Pew Internet & American Life Project, February 23, 2012,, accessed on March 13, 2012.
Friday, March 09, 2012
Clint Nelms, Network Infrastructure Practice Manager
We don’t need to look too far back to recall a recent natural disaster. When it comes to local governments, there are a lot of things to consider and for which to prepare when it comes to natural or man-made disasters – including what happens to your city’s critical data when something goes wrong.

Losing critical data can hinder not just the city but also the businesses in the community. Even with that as a backdrop, many local governments don’t have the contingency plans in place to protect their cities’ valuable data – whether the loss stems from a hurricane, earthquake, snowstorm or even something much less dramatic like a busted water pipe in the building.
  • What are you doing today for data backup? Are we still swapping tapes after a nightly backup?
  • Who is checking our backups?
  • Are all of our servers being backed up?
  • Who in our community will be impacted if 'this' city server crashed?
  • How fast can we be back operationally if 'this' city server failed?
  • Are we ready if a disaster occurred? What is our plan? 
  • When did we last check our backups? Could we recover if it were necessary?

The reality is that an ounce of prevention is worth a pound of cure as far as data backup goes. Rather than waiting for the worst and hoping for a good outcome, consider frequent backups and offsite storage that is actively monitored, managed, and tested.
Friday, March 09, 2012
John Miller, Network Infrastructure Manager
There’s an old quote or phrase that states, “we have met the enemy and it is us.” Although the quote didn’t address technology concerns, in the world of IT security issues, the quote is rather applicable. In fact, many local governments and organizations are vulnerable to IT threats because of employees.

Employees are not deliberately posing threats to their organizations. The issue is a security threat called social engineering defined as a type of fraud in which the bad guys obtain information or computer system access through trickery or deception of an individual. 

Nearly 50 percent of businesses have suffered social engineering attacks according to recent report by Dimensional Research. The same report shows that 34 percent of respondents also are not educating employees of such dangers. 

Ignorance is Not so Bliss
Poorly trained employees are a major concern in the world of IT security. In fact, educating them about possible threats is the first step in addressing the issue. According to Network World, every employee is a viable target. Eighty percent of those scammed aren’t the executives in the C-suite with access to all of a company’s data. It is the “regular” worker bees who provide easy access to the fraudsters.

Educating employees and thinking like the hackers will put your local government ahead of the game when it comes to social engineering. Moreover, if you can think like a fraudster, you can take the necessary steps to prevent breakdowns.
Once employees are “educated”, take steps to keep them aware and send out regular reminders about policies such as limited or no visitation of social media sites and restrict use of company email for personal reasons.  

Who is at risk
Some local governments may think they are immune to security issues or that hackers only target the big guys. Not true. In a recent issue of Government Technology reported that an Arkansas’ sheriff’s office website had been hacked and that it was one of 70 law enforcement agencies in several states that had been victimized by hackers.

Take the time to roll out the necessary policies and training to minimize the risks to your local government and find out what other security solutions may help stem social engineering.
Thursday, January 05, 2012
Todd Snoddy, Senior Software Developer
I recently wrote a quick blog posting regarding things to consider when making the decision to develop a native or web-based mobile app.  Once a decision is made to develop a mobile web app, the developers given the task of implementing that app will likely need to consider which mobile devices their web app should target, and how the content should be displayed on devices with different resolutions.  Should the content scale automatically, or should the developer implement multiple views optimized for different resolutions?  One good reference that I came across which discusses this in more detail is located here:
Like many problems in software development, there is no “one size fits all” solution.  The article mentions a “hybrid approach” that provides good results, but it introduces some complexity and additional effort, so there are some tradeoffs to consider which will impact development time, cost, and user experience.  The bottom line is that making the decision to develop a mobile web app is just the first technical decision among many.  Unless the phrase “money is no object” applies to your project budget, you’ll want to consider your target audience and try to identify that “sweet spot” of which devices should receive a premium user experience, and then have a fallback plan for how other devices should be handled.  Lastly, don’t forget to test on multiple devices too.  HTML should be admired for trying, but there is no such thing as a “write once, run everywhere” technology.
Wednesday, December 07, 2011
Clint Nelms, Network Infrastructure Practice Manager
Do you know anyone who has had their email address compromised?  Have you started to receive spam emails from friends or family members?  Unfortunately this sort of compromise has become more and more prevalent.

Incidents like these indicate someone has used a password guesser to gain access to your mailbox.  Spammers do this to get your address list. They then blast out spam to everyone in your contacts.  Besides being a hassle, this sort of breach makes you feel like your privacy has been violated.  

How to Fight Spammers
Many online services such as Hotmail, Yahoo!®, and local services such as BellSouth are under attack constantly.  Once your account has been compromised, what do you do?  
  • Contact friends and family and tell them not to open any suspicious emails or links from your compromised account.  
  • Immediately change your password. Use a complex password with letters, numbers, a capital letter and a special character such as a dollar sign.  
  • Contact customer support and let them know your account has been compromised.  
What about prevention? 
Google has launched a service called, “2 factor authentication.”  In this configuration you need to authorize a computer before it can be used to check your email, this includes tablets, smart phones, and etc.  To verify your account, you can ask Google to text a verification code to your cell phone. Once you receive the text, log into your mail account on a new computer and you will be prompted for that code. 

The service also creates custom passwords to be entered into smart phones.  In this case, your smart phone uses this code instead of your actual password to check your mail. Although this method is a bit cumbersome, once set up, you will have the peace of mind to know that your mailbox is much more secure and that access to your mailbox can only be accomplished from a device you have authorized.  

For more info on how to set this up, click here.
Thursday, December 01, 2011
Clint Nelms, Network Infrastructure Practice Manager
Forced with budget cuts, local government agencies have turned to cloud computing to streamline their IT needs, lower hardware expenses and improve accessibility and mobility to necessary data. 

In a special report on cloud computing, The Center for Digital Government, in partnership with Public CIO, compiled a list of five government cloud success stories, two of which are at the local government level. 

  • Problem: One year ago, the state of Wyoming was operating 13 different e-mail platforms in its executive branch. Each system required dedicated staff to maintain it, and myriad platforms meant the state lacked a shared address book across all agencies. 
  • Solution: In less than nine months, the state has migrated to a single cloud-based solution, and moved 10,000 state employees to the new platform. The move will save the state more than $1 million annually, but cost reduction is not the only benefit. State employees are able to collaborate in ways that were not possible before. 
  • Problem: What builder isn’t troubled by permit requirement delays? 
  • Solution: By moving to a cloud-based solution for issuing permits, Oregon is dramatically accelerating the approval process for contractors, builders and developers. Oregon’s cloud solution will eliminate jurisdictional confusion and time-intensive paper chases. 
  • Problem: Four years ago, Nebraska was nearly ready to replace its creaky electronic applicant tracking system with a new application. 
  • Solution: Fourteen months into its cloud implementation, Nebraska has a new, more efficient and flexible paperless applicant tracking system, and an entire human capital suite that includes learning performance, succession and compensation management; a better benefits enrollment process; e-procurement; and a core human capital database. 
Hudson County, N.J. 
  • Problem: Ten years after September 11th, disaster recovery remains foremost in county officials’ minds. 
  • Solution: A private county cloud that took just eight months to build now provides back-up for all critical data and applications. Even if county offices are compromised, personnel can log in from any location and keep things going. The Hudson County IT Division’s plan is to offer servers on demand to all the towns in the county, turning its private cloud into a community one.
Nashua, N.H. 
  • Problem: For 30 years, Nashua, N.H., used an internal IT system that had, like a monster in a science-fiction movie, spread its tentacles into every agency in the city. 
  • Solution: When this system was replaced with a hosted ERP solution, city managers are able, to see integrated numbers that show what’s really happening in the city, find and eliminate waste, and change processes when needed. 
The report also takes a deep dive into the evolution of cloud computing technology, identifies the emerging trends, and discusses the exciting implications it has for the future of service delivery. Click the link below to read the results.

| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 |
Contact a Sophicity Consultant Now To Find Out How We Can Help Reduce Your IT Costs Go