Jacques Malgrange

This lightweight plugin makes it easy to install the millions of GEONAMES Data on your WordPress site. 
It allows :
<ul>
<li>Install data from one or more file (place & postal code) ;</li>
<li>Choose column to install to avoid excessive enlargement of the base ;</li>
<li>Choose type of data to install (city, park, road…) ;</li>
<li>Remove all the data.</li>
<li>Check data in the database.</li>
<li>Edit and change datas from Dashboard.</li>
<li>Display the places on OpenStreetMap.</li>
</ul>
A shortcode is also available to create a city region and country taxonomy.
This plugin will give you plenty of ideas to improve the quality of your website.
Official <a href="http://www.geonames.org/" rel="nofollow ugc">GeoNames</a> website.
<h3>1.9.1</h3>
05/12/2024
<ul>
<li>Fix XSS vulnerability in shortcode attributes</li>
<li>Fix translation issue with WP 6.7</li>
</ul>
<h4>1.9</h4>
18/10/2024 – Fix XSS vulnerability on geoSearch field
<h4>1.8</h4>
08/02/2022
<ul>
<li>Update Leaflet 1.7.1.</li>
<li>Update SumoSelect 3.4.2.</li>
<li>Split admin sidet in a specific file.</li>
</ul>
<h4>1.7</h4>
21/03/2020
<ul>
<li>Fix issue with very long line in Geoname DB.</li>
<li>Add nonce.</li>
<li>Braces style standardisation in the code.</li>
</ul>
<h4>1.6</h4>
14/03/2019 – Add Postal code database.
<h4>1.5.1</h4>
27/01/2018 – Curl used by default if exists in place of File_Get_Content.
<h4>1.5</h4>
12/01/2018 – Add tab to edit and change datas.
<h4>1.4</h4>
24/06/2017
<ul>
<li>Add Taxonomy.</li>
<li>Add shortcode to create taxonomy in the site.</li>
<li>Add template to customize the taxonomy form.</li>
<li>Ability to download multiple files in one click.</li>
<li>Check the database with a taxonomy form and display the place on OpenStreetMap.</li>
<li>Multisite.</li>
</ul>
<h4>1.3</h4>
09/10/2015 – Fix “Fatal error: Out of memory (allocated xxx) (tried to allocate xxx bytes)”.
07/06/2016 – 1.3.1 – Fix error when reactivate (header already sent…).
<h4>1.2</h4>
06/08/2015 – Fix installation bug.
<h4>1.1</h4>
01/12/2014 – Add Ajax hook.
<h4>1.0</h4>
25/11/2014 – First stable version.

WP GeoNames

Allows you to insert all or part of the global GeoNames database in your WordPress base.

Improve My City

Improve My City for WordPress is a platform for managing local issues; from reporting, to administration and analysis.
It is an integrated solution aimed to local governments seeking collaboration with their citizens, freely available as open source.
<h4>Report</h4>
Collecting issues via web or mobile.
<ul>
<li>
Reported via web or mobile
By allowing citizens to report issues from their home using the web version, or while on the street using the mobile app (iOS & Android).
</li>
<li>
Easily composed but descriptive
By asking citizens to provide only the information necessary to locate and resolve the issue, such as title, description, location and category.
</li>
<li>
Accurately positioned
By offering a map to facilitate citizens in determining the exact location of their issue.
</li>
<li>
Picture enabled
By allowing to attach an image on the spot for describing the issue.
</li>
<li>
Categorized based on their nature
By urging citizens to select one of the pre-specified categories reflecting the municipality departments.
</li>
<li>
Commented and voted
By offering the mechanisms to post comments or vote for issues that have been submitted by other citizens.
</li>
</ul>
<h4>Administer</h4>
Easy to use administration platform.
<ul>
<li>
Browse effectively
Issues are presented on the city map, as an ordered list but also in a single-issue page displaying the full set of submitted details.
</li>
<li>
Distribute responsibilities
Assign one or more officers per category and split the administration effort across the municipality departments.
</li>
<li>
Track pending issues
Issues are automatically routed not only to the appropriate department but also to the inbox of the responsible officer.
</li>
<li>
Monitor progress and update citizens
Resolve issues and inform citizens by email or through a progress indication bar (Open -> Acknowledged -> Closed).
</li>
<li>
Provide direct feedback
Provide written feedback to the citizens giving non-standard explanations for each specific case.
</li>
<li>
Customize easily
Fully customize the system in terms of user rights, number and nature of categories, notification rules and localization settings.
</li>
</ul>
<h3>Documentation</h3>
<h4>[1] Set IMC Main Page</h4>
The Improve My City Main Page (IMC-Improve My City Main Page) is located on Pages > IMC Improve My City Main Page.
After activating the plugin, a page called “IMC – Improve My City Main Page” is automatically created. This is the core page of the plugin, where all the issues will be presented. You can add it on a menu, or assign it as you front page. If you ever delete this page or any page that is created by the Improve My City plugin you can bring them back by disabling and enabling the plugin again.
<ul>
<li>[1.1] Add Improve My City Main Page to your main menu</li>
</ul>
<ol>
<li>Visit Appearance > Menus</li>
<li>Choose an existing menu or create a new one.</li>
<li>Search and Add to Menu the “IMC – Improve My City Main page” from the Pages section.</li>
<li>Choose a location for your menu at Theme locations and save it.</li>
</ol>
<ul>
<li>[1.2] Set Improve My City Main Page as your site’s Front page</li>
</ul>
If you want to use the Improve My City Main Page as your front page, go to Settings > Reading and set “Front page displays” to “A static page”. From the dropdown menu, select the “IMC – Improve My City Main Page”.
<h4>[2] Issues & Categories</h4>
<ul>
<li>[2.1] Before creating your first Issue</li>
</ul>
Each issue that is submitted to the “Improve My City” platform is assigned a Status and a Category. Statuses denote the progress of an issue. You can have as many statuses as you want, although it is best to limit the number of statuses to 6. You can have as many Categories as you like.
Before using the plugin to report issues, there has to be at least one Status and one Category set, so the plugin can function as intended.
In the following sections, it is described how to manage the Statuses & Categories.
<ul>
<li>[2.2] Manage Statuses</li>
</ul>
To access the Status manager navigate to Improve My City menu > Issue Statuses.
On the left hand side of this screen you can add a new status by providing the necessary information:
<ol>
<li>Name: The Status name that will be shown everywhere in the application.</li>
<li>Slug: The unique identifier of the Status. It usually is the status name in lowercase without special characters and spaces.</li>
<li>Description: A short description about the status that is usually used internally to convey information between administrators.</li>
<li>Color: A unique color that best represents the status. Use the color picker to select from a predefined color or set your own.</li>
</ol>
Then click on the Add new Status button to save it.
You can also edit an existing Status.
On the right hand side of this screen resides the Status table that lists all of your created statuses. The chronological order that they are created, define the order of each step (as seen in the order field).
For example the first status that you create, is also an issue’s first (initial) status (the one with the smallest order number). The second one is the status after the initial, and so on.
There is a soon to be implemented ordering mechanism to enable setting the ordering manually.
<ul>
<li>[2.3] Manage Categories</li>
</ul>
To access the Category manager navigate to Improve My City menu > Issue Categories
On the left hand side of this screen you can add a new category by providing the necessary information:
<ol>
<li>Name: The Category name that will be shown everywhere in the application.</li>
<li>Slug: The unique identifier of the Category. It usually is the category name in lowercase without special characters and spaces.</li>
<li>Parent: Use this dropdown if you want to make this Category a sub-Category; you have to select the sub-category’s parent category. “Improve My City” can only support depth of one level.</li>
<li>Description: A short description about the category that is usually used internally to convey information between administrators.</li>
<li>E-mail Notifications: The e-mail address that will receive all notifications about any changes. You can use more than one if you like, by separating them with a comma. By leaving it blank, it means that all the notifications for this category will be sent to the website’s admin mail (WordPress admin).</li>
<li>Category Image: Select an icon that will represent this category. Icons should have at least 100×100 pixels size and background transparency. 
Then click on the Add new Category button to save it.</li>
</ol>
You can also edit an existing Category.
On the right hand side of this screen resides the Categories table that lists all of your created categories.
<h4>[3] Issue Reporting</h4>
In the following section, the default roadmap on how to report an issue is described, both from the frontend and from the administrator panel.
<ul>
<li>[3.1] Report an issue (Citizens)</li>
</ul>
To report a new issue as a citizen: 
1. Visit Improve My City Main Page on your website. 
2. Click on Report an issue link at the top right of your screen 
3. There are five pieces of information associated with each new Issue that you need to fill in.
Title: Add a short title for the issue
Category: Select an appropriate category from the dropdown option.
Description: Write a thorough description of the issue.
Address: Add the specific address of issue’s location. By dragging the pin icon on the map, the Address field is populated automatically. You can also start typing and the auto-complete feature will suggest an address based on your location. The Locate button is used to make sure that the address entered is correct.
Photo: (optional) Attach a photo of the issue. Photo size must be less than 2MB.
<ul>
<li>[3.2] Report an issue (Administrators)</li>
</ul>
To report an issue as administrator: 
1. Visit Improve My City > Add New at your dashboard 
2. There are six pieces of information associated with each new Issue that you need to fill in.
Title: Add a short title for the issue [4.2.1]
Description: Write a thorough description of the issue [4.2.2]
Address: Add the specific address of issue’s location. By dragging the pin icon on the map, the Address field is populated automatically. You can also start typing and the auto-complete feature will suggest an address based on your location. The Locate address button is used to make sure that the address entered is correct. [4.2.3]
Category: Select an appropriate category from the dropdown option. [4.2.4]
Status: Select an appropriate status from the dropdown option. [4.2.5]
Photo: (optional) Attach a photo using the Featured Image field. [4.2.6]
You can also enable/disable comments for this issue by checking/unchecking the “Allow Comments” checkbox.
<h4>[4] Improve My City Settings</h4>
The Improve My City Settings are located on Settings > IMC Settings, spanning 3 tabs.
<ul>
<li>[4.1] Settings regarding Google Map</li>
</ul>
In this tab resides all the configuration options about the Map functionality of the plugin.
<ol>
<li>Google Maps API KEY: Add your API Key to authenticate requests about your Google Maps. For more information on getting an API Key, see the Google Developers website.[5.1.1]</li>
<li>Initial Address: Add specific address that every map in IMC will have as default. By dragging the pin icon on the map, the Initial Address field is populated automatically.[5.1.2]</li>
<li>Initial Latitude: Add a specific latitude value that every map in IMC will have as default.[5.1.3]</li>
<li>Initial Longitude: Add a specific longitude value that every map in IMC will have as default.[5.1.4] 
Note: The 5.1.3 and 5.1.4 values are populated automatically when you set an Initial Address on 5.1.2.</li>
<li>Initial Map Zoom: Set the default zoom of the map. Available values range between 0 and 20.[5.1.5]</li>
<li>Map Language: Change the in-map language as well as the directions output language. See supported list of languages.[5.1.6]</li>
<li>Map Region: Change map region to apply bias for IMC behavior towards your Region. See Unicode region subtag identifiers.[5.1.7]</li>
<li>Allow zooming with mouse scroll wheel: Choose if you want to enable zooming on the map, using the mouse scroll wheel.[5.1.8]</li>
<li>Clustering markers: The map clustering functionality will be available and thoroughly documented at a later time.[5.1.9]</li>
<li>Boundaries: Insert a GeoJSON object, extracted from the OpenStreetMaps page to display your city’s boundaries and allow reporting only inside these limits.[5.1.10]</li>
</ol>
<ul>
<li>[4.2] Settings regarding Notifications</li>
</ul>
In this tab the administrator can enable or disable the dispatch of notification e-mails for a range of the plugin actions.
<ol>
<li>On new issue to user: Send an e-mail notification to Citizen, immediately after reporting an issue.[5.2.1]</li>
<li>On new issue to admins: Send an e-mail notification to Admins, immediately after an issue reported on their Category (See [3.2]).[5.2.2]</li>
<li>On change category to user: Send an e-mail notification to Citizen when his issue has changed category.[5.2.3]</li>
<li>On change category to admins: Send an e-mail notification to Admins, immediately after an issue has moved to their category (See [3.2]).[5.2.4]</li>
<li>On change status to user: Send an e-mail notification to Citizen when his issue has changed status.[5.2.5]</li>
<li>On change status to admins: Send an e-mail notification to Admins (See [3.2]), immediately after an issue has changed status.[5.2.6]</li>
<li>On new comment to admins: Send an e-mail notification to Admin immediately after a comment is published.[5.2.7]</li>
</ol>
<ul>
<li>[4.3] General Settings</li>
</ul>
In this section the administrator can set whether new issues will be published immediately, or will be moderated at first.
<ol>
<li>Moderate new Issues: Set if you want to moderate new issues. This means that when a citizen reports an issue, it is saved as a draft, so an administrator can check the issues information first and then publish it. [5.3.1]</li>
</ol>
<h4>[5] Roles and Capabilities</h4>
<ul>
<li>[5.1] Roles of Improve My City</li>
</ul>
A Role defines a set of tasks that an assigned user can perform. Improve My City plugin uses three different roles for giving the ability to control what users can and cannot do within the platform.
<ol>
<li>Administrator: (WordPress default role) A user that has access to everything in your site and the entirety of the Improve My City plugin.</li>
<li>Department Admin: (Custom role) A user that has access to the entirety of the Improve My City plugin but not on the rest of the website.</li>
<li>Subscriber: (WordPress default role) This role is the default for citizens. It allows reporting, editing and browsing issues on the front end, while it denies access to the administration platform.</li>
</ol>
<ul>
<li>[5.2] Add New User as Department Admin</li>
</ul>
You can create a new Department Admin user by visiting Users > Add New and selecting “Department Admin” as a Role option.
<h4>[6] Important Notes</h4>
<ul>
<li>[6.1] Allow citizens to report issues</li>
</ul>
In order to allow citizens to report issues, you need to enable registration to your website. 
1. Visit Settings > General 
2. Check Anyone can register at Membership option 
3. Select Subscriber at New User Default Role option 
4. Provide Login & Register Links at your site

Direct citizen-government communication & collaboration.

WP GeoNames vs Improve My City