Slashdot Mirror
Ask Slashdot: What Web Platform For a Small Municipality?
First time accepted submitter r3dR0v3r writes "I have the opportunity to help improve / replace the website of my small U.S. town (~6000 people). The town leaders are open to most any suggestions, and are open to the idea of having the website facilitate a more open government — by being a place at which town documents, meeting agendas, meeting minutes, legal forms, ordinances, etc. can be found in an organized way and downloaded. And of course the site should provide general info about the town, it's services, recreation opportunities, etc.. Now, we have no budget, so we'll be looking at free/open software. I've considered options such as Drupal, but I'm doing this as volunteer work so I don't want to start from scratch and spend overly much time. Thus, I'm looking for advice about any existing platforms made specifically for municipalities as a great way to get a jump start. I'm guessing there are other slashdotters that have helped their communities in this way. Your suggestions please?"
Use a CMS like Joomla, Drupal (or any other similar)
Or, if you're a glutton for punishment, Sharepoint. (yes, that is a joke)
Agent K: A *person* is smart. People are dumb, stupid, panicky animals, and you know it.
Drupal with CiviCRM. Perfect for what you've described.
Make sure to have a clear support contract, paid or otherwise. This could become an unpaid time sink unless you set clear time and other boundiaries NOW. You may not notice if you do,but you will pay if you don't.
Silence is a state of mime.
Do not listen to this advice. RoR is totally fail. It sucks at performance, scaling and pretty much every other metric that is important.
LAMP... well acronym for the grammar Nazis
That would be lexicology Nazis, you semantics-insensitive clod!
Sincerely yours,
lexicology Nazi.
Ezekiel 23:20
Actually, joomla and wordpress both have multiple free extensions that handle Facebook comments, Disqus comments, twitter feeds, etc.
This is where I pitch www.codeforamerica.org and see what it may offer!
Colin Dean Go a year without DRM
Because 300 connections to the database to display a picture of your cat can't be wrong.
For the type of things you're looking for, I'd recommend LocalWiki. While so far it's been used mostly by communities vs municipalities, it includes robust permissions, is under active development, and is built w/ some nice geo-extensions for where that's applicable. It's very easy to get up and running and you could run a micro EC2 instance to test out for (practically) free.
I'd also suggest that you try to connect w/ others that are doing similar things. There's a large community of civic hackers. For those working directly w/ municipal govt, check out the Code for America Brigade, a community that's all about that and can provide help/support for exactly this sort of thing. You may want to check out their deployable app list, and maybe also check out CfA's github repository which has a lot of projects that may be useful, and their Civic Commons project which gathers the sw/infrastructure that cities are using.
...harder than it has to be.
Google Sites + Drive
The primary purpose of the site is to share information. This would also make it easier to have the town update/work with the site themselves.
with info about the town that does not change (name, location info, some pictures, etc)
2. Create the town's Facebook page, populate it with dynamic data, and hand over control of the account to the town manager (or whoever)
3. Embed Facebook data into your static html page
You can go Drupal or Joomla but do you really want to be responsible for security and upkeep? Joomla in particular gets hacked a LOT. Drupal is a nightmare to train newbs how to use.
Based on your stated requirements (no budget, not wanting to start from scratch etc) I'd suggest using one of the many pre-configured Drupal distributions like OpenPublic (http://drupal.org/project/openpublic) which is built specifically for the needs of government.There are many other distributions available at http://drupal.org/project/distributions. Using one of these will save you a lot of time.
The increased staffing required to develop and maintain it will drive your little town's population up to 20,000 in short order. Best of all, most of those new jobs will be for highly paid SharePoint consultants, so the town should get a lot more property tax revenues!
This is not pessimism; it's realism: stop while you're ahead, or at least hammer out an agreement in writing.
Doing any sort of web development for a large community, and gods forbid a government agency, is going to eat up a lot of your time -- time you've already said you don't have. Worse, though, is that it will never end... your involvement will become increasingly needed and even demanded as services fail or need to be expanded, or your site is hacked. How much liability are you assuming in designing what amounts to the PR page for a group of professional, elected lawyers?
You absolutely need to make sure that there are clearly-defined boundaries at every level of your involvement, preferably in the form of a contract, even if the work is completely voluntary.
It's not always cost-effective to host your own platform - you need hardware, power and cooling, a reliable internet connection with good upload speed, maintenance, backup, etc. and you get to live with a pager, There are plenty of cheap Linux hosts out there where all the possible software is available. As an example there is Bluehost where the $5/month hosting plan comes with a SimpleScripts subscription which allows you to deploy just about any application in a jiffy (including all the CMS, blogging and social media stuff you can think of, including Drupal). Of course for that price you can't expect stellar performance, there will be hundreds of other websites on the same machine.
If you want something more robust and you are open to other things than FOSS than have a look at Microsoft Azure. It's more expensive than cheap Linux hosting but for $25-$50/month you can have a very robust cloud setup (load balancing, backup, etc) and no additional license cost. And the nice thing on Azure is that you can deploy an configure a new CMS (like Joomla or DotNetNuke) using a click wizard, it's even more user-friendly than SimpleScripts, you get to choose the various options, not just the admin password. Also with Azure you get a 3 months free trial to see if you like it. And if you somehow can't sleep with the idea of a .Net webapp you can deploy PHP stuff - you can even host a Linux VM and run whatever you want on it but that would kinda defeat the purpose of using cloud services.
Whatever you do make sure you don't become the "owner" of a local setup. People will start to have unrealistic expectations and will be mad at you when "your" server is down because of a power or internet failure. If you really can't afford a few dollars a month go see an elected official and ask for guidance, I'm sure they can find a federal program to get you pennies.
lucm, indeed.
I would use CiviCRM [1] and WordPress if there were no other constraints. I am of course assuming that your town wants to be able to do email outreach, has events, and likely could use case management to handle citizen requests. If not, then there is little point in using CiviCRM or anything besides a plain CMS.
I personally would prefer seeing town meeting summaries as blog posts then PDFs (which is what most towns seem to do currently).
Although if you really have NO budget, then I guess WordPress.com hosted or Google Sites.
[1] http://civicrm.org/
Just a few questions to see if you've even bothered to think about this beyond "Websites are cool, open is awesome!"...
These questions all come from firsthand experience.
1) Who will maintain the data on the site?
a) Does the city have the budget for them to do this?
b) Will there be resistance to the amount of work they have to do / training they have to take?
c) Will you train them?
2) What do the solicitors think? Will they even let you post what you want on the site?
3) Do the departments want the information available? Are they going to push back if they don't?
4) You have no budget. Who pays for or does the hosting? Registration? Admin stuff? Maintenance?
5) Do you actually have buy-in from the people you need it from, or are they just humouring you?
6) Are you being used? This is the sort of thing that municipalities (Yes, even your small one. Look at its tax roll sometime) can easily justify dumping $20k+ into
7) They have done a feasibility study, right?
8) How familiar are you with accessibility standards? Are there some you legally must meet to even put the site up?
9) Who is responsible for the site itself?
10) Are you prepared to have this project drag on for over a year?
11) Finally, the hardest one - are you certain you know the scope of the project?
Good luck, but don't get yourself in trouble...
Out of the box, it has probably more than what you want. http://openpublicapp.com/
--Steve
Also, RoR is a framework for creating a website from scratch, which is exactly what the poster did not want to do. There may be CMS packages written in RoR, but Ruby by itself will take a lot more work than he wants.
WTB [sig], PST!!!
WordPress recently started a service specifically for municipalities: http://en.blog.wordpress.com/2012/11/14/wordpress-for-cities/ Even with their paid upgrades, you would probably be saving money on development and you are paying for hosting or (bandwidth/power) anyway.
My small town of ~5,000 uses http://www.govoffice.com/ and it does everything you speak of.
Even better word is...VM. There are several Linux distros with VM support built in and VMWare has several LAMP builds already set up and ready to go.
Why a VM?because its pretty obvious that if this guy is going to ask Slashdot he has little to no experience at the task at hand (because if he did he'd already have preferences) so he is gonna make mistakes and with snapshots he can just roll back the image if he makes a boo boo without wasting all his previous efforts. So the smart move would be a minimal distro with VM support and one of the prebuilt LAMP setups from some place like VMWare, its the choice with the fewest risks.
ACs don't waste your time replying, your posts are never seen by me.
Since, in a gig like this, you can never enforce your own conditions (like saying you won't amend the design on every whim) you have to let the tools enforce this for you.
If I was ever to try this again I would opt for an easily user-editable, hosted solution. Wordpress will be ideal: http://en.blog.wordpress.com/2012/11/14/wordpress-for-cities/ You can cast your role as advising them on how to run it: information architecture; doing the limited number of graphics and showing people how to use the editor. Your role is not to continually re-design (just customise the template), nor to populate the whole thing. You'll also not have to put up with a 2am phone call from the Mayor to say your site is flagged as having malware and is littered with anti-city comments. Wordpress will deal with that for you.
I have used Drupal (and CiviCRM) for other sites and they are phenomenal tools...I just think for a 6,000 grouping they are overkill. And remember if the city wants personalisation, user accounts, billing, consultations etc. online then they really should be paying for someone to develop it for them (perhaps using those tools).
Hosted Wordpress will also help you see whether they are ready to run their own online affairs.
Also, unlike Wordpress, Drupal does a pretty good job keeping up security.
Evidence/proof please? I don't really see them as being significantly better:
http://cve.mitre.org/cgi-bin/cvekey.cgi?keyword=joomla
http://cve.mitre.org/cgi-bin/cvekey.cgi?keyword=drupal
http://cve.mitre.org/cgi-bin/cvekey.cgi?keyword=wordpress
http://cve.mitre.org/cgi-bin/cvekey.cgi?keyword=plone
http://cve.mitre.org/cgi-bin/cvekey.cgi?keyword=django
OK they only had 5 sql injection CVEs in 2012 while Wordpress had 6. But "pretty good job" doesn't seem to spring to mind when I look at the Drupal CVEs.